how to make a editable query in openoffice base

Usually the 'public' scheme contains the user tables. Then click on 'Tables' in the next screen to see the existing PG tables in the database.This file you can use later to re-establish the connection (instead of defining all again). Finish brings you to a 'Save as' dialog for the connection, saves these settings as file.To find out, ask your DB administrator or use in a terminal 'psql -l ' or, if the database is on a remote server, 'psql -h -l'. Connection settings: We have to define the server ('host') name and the name of the database, probably also the user name in case you have to connect with a different user name.Connect to existing database (select driver): postgresql.Usage of PostgreSQL driver (MS-Windows and Linux)Īfter starting again, use: File -> New -> Database to enter the DB dialog. Done (did you really close openoffice? Please do.).Restart openoffice (even the quickstarter on windows must be shut down !!!).In case you have installed an older version of the driver, remove it now.

The driver gets installed now, afterwards, the file is listed in the dialog with state enabled. Click on the add button and select the downladed file (DO NOT EXTRACT IT !) in the upcoming File dialog. Start OpenOffice, choose 'Tools/Package Manager'.download postgresql-sdbc-X.Y.Z.zip driver (take the 'recommended' file) and save the file to your disk.PostgreSQL ( 2.x) Installation of PostgreSQL driver (MS-Windows and Linux) The version LibreOffice 3.5 introduces a new PostgreSQL driver:Īlternative PostgreSQL ODBC driver perfectly works with the latest LibreOffice. Also you can check an expanded list of ODBC drivers for Oracle, SQL Server, PostgreSQL, MySQL, SQLite. There are drivers for PostgreSQL, SQLite and MS-Access mdb files. See Database drivers page for overview.Usage of OpenOffice-Base with various drivers 2.2 Step by step DB import procedure (MacOSX).2.1 Step by step DB import procedure (MS-Windows and Linux).1.2.3 Installation of PostgreSQL driver (MacOSX).1.2.2 Usage of PostgreSQL driver (MS-Windows and Linux).1.2.1 Installation of PostgreSQL driver (MS-Windows and Linux).1 Usage of OpenOffice-Base with various drivers.

How to make a editable query in openoffice base