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:

  • host is the host name of the server. Defaults to localhost
  • port is the port number the server is listening on. Defaults to 5432
  • database is the database name. Defaults to the same name as the user name.

Attributes

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

Technical

Version Supported

  • Driver 42.2.16 that supports PostgreSQL 8.2 or newer
  • Database: 9.5 or above
SELECT version();

DataType

Task Runner