Accessing a postgresql database in OpenOffice or libreoffice

If you have ubuntu, install :

sudo apt-get install libreoffice-sdbc-postgresql


In LibreOffice, create a new database. Then, in connection parameters, specify the URL : dbname=XXX host=abc.net and then the username and the password.