PostgreSQL and PostGIS

Catenivo can read and write PostgreSQL/PostGIS tables and run explicit SQL queries.

Connections

Open the connection manager from Tools. A connection defines host, port, database, user, TLS policy and timeouts.

Prefer verify-full when supported by the server and its certificates.

Passwords are separate from the project. They can be retained for the session or stored in the operating-system vault when available.

Read tables

A PostgreSQL/PostGIS reader discovers schemas, tables, views, columns and geometries accessible to the configured account.

Catenivo does not invent a missing CRS and does not silently coerce unsupported types.

Write

Writers support several strategies depending on the destination, including creation, insertion and keyed operations.

Destructive modes—truncate or recreate—require confirmation at run time. Recreating a table rebuilds the structure declared by Catenivo; it does not guarantee restoration of previous triggers, privileges or external objects.

SQL operators

Create features from SQL runs one read query and creates one feature per returned row.

Execute SQL query runs for incoming features and can operate in explicit read or write mode.

Only run trusted SQL: a transaction does not turn privileged functions or external side effects into a sandbox.

CLI and passwords

The CLI does not automatically read secrets from the graphical application’s vault. For scheduled jobs, provide passwords through environment variables using the CLI’s dedicated options.

See Command line.