Visualize a PostgreSQL Table in LibreOffice Calc

I'll then write the result to a table in my PostgreSQL database.įrom dpsdata.'OctoberCount_Archive' as oct We store the students separate from the neighborhoods they live in, so I will spatially intersect the students from our internal spatial table of October Count students with the neighborhoods. Create Spatial Query and Result Tableįor this example, I want to chart the number of students by grade in the NW Neighborhoods of Denver as defined by the City and County of Denver Statistical Neighborhoods dataset. You should have saved a file on disk that looks like this:ĭouble-click the connection to open your database in LibreOffice BaseĬhoose the Tables node to see your PostgreSQL data:ĭouble-clicking a table will give you access to the raw data - careful not to choose a table with complex polygon or linestring data, as loading the text representation will cause LibreOffice to hang.

You now have a connection to your PostgreSQL database registered with LibreOffice. Lastly, ensure you save your connection file in a place you can find it later.Įxamine your PostgreSQL database in LibreOffice Base Now finish the connection to your database.Ĭhoosing 'Yes, register the database for me' will let you save a connection file to your database, which you can use later on to access your PostgreSQL database in LibreOffice Calc, and to edit your non-spatial data.Įnabling 'Open the database for editing' will take you directly to your data in LibreOffice Base Next, add your username if prompted, and test the connection if you want. Host=servername dbname=databasename user=username password=******

Libreoffice base postgresql