PostgreSQL

Note

We have a detailed howto for your first steps with SQL databases in DSS.

You might want to start with that Howto. The rest of this page is reference information for PostgreSQL.

DSS supports the full range of features on PostgreSQL:

  • Reading and writing datasets
  • Executing SQL recipes
  • Performing visual recipes in-database
  • Using live engine for charts

DSS only supports PostgreSQL 9 (all minor versions). PostgreSQL 8 is not supported.

Installing the JDBC driver

The PostgreSQL driver is pre-installed in DSS. You don’t need any further installation.

Secure connections (SSL / TLS) support

DSS can connect to a PostgreSQL server using secure connections.