Table of Contents

PostgreSQL

About

Tabulify supports the relational database Postgresql

If you don't have any knowledge of Tabulify, you can start with the Learning Guide, otherwise you can also browser the relational database Howto's

Connection

To create a Postgres connection, you have the following possibilities

In a Connection Vault, to define a Oracle connection with the name myPostgres, you would write:

[myPostgres]
[postgres]
url = jdbc\:postgresql\://host\:[port]/[databse]
user = postgres
password = xxx
driver = org.postgresql.Driver

The password will be encrypted the next time that you start a Tabulify product such as Tabli

With the tabli add command of the connection module, adding a Postgres connection with the name postgresConnectionName:

  • With the Windows CMD console
tabli connection add "postgresConnectionName" "jdbc:postgresql://[host]:[port]/[database]" ^
    --user login ^
    --password password
  • With Linux Bash
tabli connection add "postgresConnectionName" "jdbc:postgresql://[host]:[port]/[database]" \
    --user login \
    --password password

Connection Attribute

When creating a new connection, you may give the following properties.

URL

The URL can take one of this form

jdbc:postgresql:database
jdbc:postgresql:/
jdbc:postgresql://host/database
jdbc:postgresql://host/
jdbc:postgresql://host:port/database
jdbc:postgresql://host:port/

where:

Attributes

All possible attributes can be found in the Postgres connection documentation.

Technical

Version Supported

SELECT version();

DataType