PostgreSQL
From Bobs Projects
Revision as of 21:20, 5 September 2011 by Bob Edwards (Talk | contribs)
PostgreSQL is an open-source SQL database server.
Use with Open/LibreOffice Base
PostgreSQL is a supported backend database for openoffice.org/libreoffice "base" database application. On Debian/Ubuntu Linux, install openoffice.org-sdbc-postgresql:
# apt-get install openoffice.org-sdbc-postgresql
Then start openoffice.org/libreoffice "base" and select "postgresql" as the backend database. During 2nd stage of configuration, enter:
dbname=databaseName host=databaseHost
In the third configuration screen (Authentication), enter database username and tick the password prompt box.
Finish configuration.
Then enter password to connect to PostgreSQL backend server.