PostgreSQL endpoint

Connection string

You can connect to Seafowl's PostgreSQL endpoint by using a DSN as follows:

postgresql://localhost:6432/anydbname

See the configuration reference for more information on configuring the host/port.

This endpoint ignores the username/password and the database name, as well as doesn't support SSL.

Exposed tables

The PostgreSQL endpoint exposes all tables and schemas from the default database.

Supported queries

The PostgreSQL endpoint supports all Seafowl queries apart from CREATE FUNCTION:

• SELECT
• CREATE TABLE, CREATE TABLE AS and other DDL
• INSERT, UPDATE and other non-SELECT DML