Connecting to Existing PostgreSQL Database Table

users
#1

I have a postgres database on my server (running Slackware-13.1) and want
to access a table for data entry using LO on my workstation (running same
distribution and version).

   Using LO-3.4.3, what steps do I follow to establish the connection? I try
File -> New -> Database, but the options there want me to create a new
database apparently outside of postgres. File -> Open does not offer me the
option of connecting to an existing database.

   When I try File -> New -> Database -> connect to existing database, I've
no idea what to specify with either jdbc or odbc. Pointers greatly
appreciated.

Rich

#2

Rich

  I have a postgres database on my server (running Slackware-13.1) and want
to access a table for data entry using LO on my workstation (running same
distribution and version).

  Using LO-3.4.3, what steps do I follow to establish the connection? I try
File -> New -> Database, but the options there want me to create a new
database apparently outside of postgres. File -> Open does not offer me the
option of connecting to an existing database.

  When I try File -> New -> Database -> connect to existing database, I've
no idea what to specify with either jdbc or odbc. Pointers greatly
appreciated.

Rich

Ubuntu has the following extension for libreoffice-sdbc-postgresql that allows easier integration with Base. I do not have Postgres installed so I can give more detailed instructions. If I remember correctly it is much more user friendly.

#3

Hi Rich,

  When I try File -> New -> Database -> connect to existing database, I've
no idea what to specify with either jdbc or odbc. Pointers greatly
appreciated.

If you have the libreoffice-sdbc-postgresql connector installed,
available on Ubuntu-based distributions (not sure about others), then
you should see a postgresql entry in your list of existing connection
possibilities.

There was a problem with writing to the database with this native
driver, it has been worked on by a developer in the past few months, but
I don't think the corrections have been integrated into the master
source code repository of the Libreoffice project yet.

If you do not have the native postgresql driver, then you can use JDBC,
but you have to use the JDBC3 postgresql driver, and performance is
well, below par, for anything but a very small and uncomplex datatabase.

In the archives of this mailing list, I have already written how to
setup a JDBC connection to a postgres db.

Alex

#4

Hi :slight_smile:

I tried searching the archives but could only find these 2 links
http://nabble.documentfoundation.org/Postgresql-with-LibO-3-3-2-BASE-td2784421.html

http://nabble.documentfoundation.org/Postgresql-with-LibO-3-3-2-BASE-td2794187.html

I would like to copy&paste the answer into a wiki and then work at the
formatting later. Which would be a better address?
http://wiki.documentfoundation.org/Documentation/Base/PostGreSql
or
http://wiki.documentfoundation.org/Documentation/PostGreSql
or just use
Postgresql

Note there already is a page
http://wiki.documentfoundation.org/Base
but that is meant to help people collaborate across the various lists and we
haven't been able to promote it much so it's almost unused at the moment. I
think a mailing list dedicated to Base is the only way to get cross-list
collaboration and build-up a team.

Regards from
Tom :slight_smile:

#5

If you have the libreoffice-sdbc-postgresql connector installed,
available on Ubuntu-based distributions (not sure about others),

Alex,

   As I wrote in my original message, I run only Slackware. Doesn't matter
what ubuntu has available as it does me no good. I've not found an
equivalent for slackware.

In the archives of this mailing list, I have already written how to setup
a JDBC connection to a postgres db.

   I'll take a look.

Thanks,

Rich

#6

Hi Tom,

Tom wrote (15-11-11 13:05)

I tried searching the archives but could only find these 2 links
http://nabble.documentfoundation.org/Postgresql-with-LibO-3-3-2-BASE-td2784421.html

http://nabble.documentfoundation.org/Postgresql-with-LibO-3-3-2-BASE-td2794187.html

I would like to copy&paste the answer into a wiki and then work at the
formatting later. Which would be a better address?

Looks a good idea. Thanks for that.
(Mind I did not look at the info itself.)

http://wiki.documentfoundation.org/Documentation/Base/PostGreSql
or
http://wiki.documentfoundation.org/Documentation/PostGreSql
or just use
Postgresql

First would have my preference.
However, as fas as I remember, adding the right tags or keywords to the wiki page, is used for proper tracking, linking etc.

I would suggest that either you take example of existing pages, or you ask at the Website list.

Cheers,

#7

Perhaps these will be of help?
http://repository.slacky.eu/slackware-12.2/PACKAGES.TXT

PACKAGE NAME: hsqldb-1.8.0-i486-1ld.tgz
PACKAGE NAME: unixodbc-2.2.14-i486-2sl.tgz

http://jdbc.postgresql.org/documentation/80/index.html
http://jdbc.postgresql.org/download.html
http://www.postgresql.org/docs/9.1/static/index.html
http://wiki.postgresql.org/wiki/Main_Page

Can't suggest any more than that as I do not have slackware. Good luck.

#8

Sorry, forgot this one:
http://www.faqs.org/docs/ppbook/book1.htm
While that isn't a how-to with LO, it is a good reference on postresql
overall, including using & clients etc.

And found this regarding the sdbc:
https://bugs.freedesktop.org/show_bug.cgi?id=35683
[RFE: consider adding SDBC into libreoffice for better access to postgresql]
Perhaps it will be taken care of in 3.5.

#9

Hi All,

And found this regarding the sdbc:
https://bugs.freedesktop.org/show_bug.cgi?id=35683
[RFE: consider adding SDBC into libreoffice for better access to postgresql]
Perhaps it will be taken care of in 3.5.

The code is being integrated as a build option into master as we
speak/write, i.e. it should soon be possible to build the
sdbc-postgresql-connector directly from the main code repo as an
OXT-extension.

Alex

#10

Hi Rich,

In the archives of this mailing list, I have already written how to setup
a JDBC connection to a postgres db.

  I'll take a look.

I indicated how to do the JDBC setup in my post of April 8th, 2011.

Alex