Querying the PostgreSQL endpoint

Seafowl also comes with a PostgreSQL-compatible endpoint. This endpoint is unauthenticated and unencrypted, which is why it is disabled by default.

To enable it, add the following to your configuration file:

[frontend.postgres]
host = "127.0.0.1"
port = 6432

You can then connect to Seafowl using a PostgreSQL client like so:

psql postgresql://localhost:6432/[any db name]

Notes

Seafowl doesn't completely implement the information_schema standard or any of the pg_catalog tables. This means that while simple clients like psql or direct connections from a language's PostgreSQL library will work, more sophisticated clients that do introspection won't.

Seafowl also doesn't support transactions. Clients or language libraries that try to manage transaction state will likely crash as well.

The PostgreSQL endpoint doesn't support some custom Seafowl statements that are defined outside of the SQL parser used by DataFusion. Currently, this only includes the CREATE FUNCTION statement.