How to Connect base to to PostgreSQL?

[cootcraig]

Version 4.0.3.3 (Build ID: 400m0(Build:3))
Ubuntu 13.04

I have a local PostgreSQL server running. I want to connect LibreOffice base to a PostgreSQL database. I do not see a native SDBC option, there is a JDBC option. How can I enable the SDBC interface? Do I need to use JDBC?

[JohnSUN]

It’s easy - see here. This is a very old article, but it works today.

[cootcraig]

I have this working now. Two things I had to fix; 1) sudo apt-get install libreoffice-sdbc-postgresql. PostgreSQL is now an option. 2) PostgreSQL 9.1 creates new users with an expired expiration date. I changed the expiration date. Now the connection works.

[cootcraig]

I have this working now. Two things I had to fix;

1. sudo apt-get install libreoffice-sdbc-postgresql.
   PostgreSQL is now an option.

2. PostgreSQL 9.1 creates new users with an expired expiration date.
   I changed the expiration date. Now the connection works.

[cootcraig]

I’ve now switched to using the JDBC PostgreSQL driver.

postgresql-9.2-1002.jdbc4.jar

I used.

connection string: postgresql:dbname

driver class: org.postgresql.Driver