PostgreSQL table function

BETA

¶

The Tinybird postgresql() table function allows you to read data from your existing PostgreSQL database into Tinybird, then schedule a regular copy pipe to orchestrate synchronization. You can load full tables, and every run performs a full replace on the data source.

To use it, define a node using standard SQL and the postgresql function keyword, then publish the node as a copy pipe that does a sync on every run. See Table functions for general information and tips.

Syntax¶

Create a new pipe node. Call the postgresql table function and pass the hostname and port, database, table, user, and password:

SELECT *
FROM postgresql(
  'aws-0-eu-central-1.TODO.com:3866',
  'postgres',
  'orders',
  {{tb_secret('pg_username')}},
  {{tb_secret('pg_password')}},
)

Publish this node as a copy pipe. You can choose to append only new data or replace all data.

Type support and inference¶

Here's a detailed conversion table:

Considerations¶

The following considerations apply to the postgresql() table function:

• Tinybird doesn't support all PostgreSQL types directly, so some types are mapped to String, which is the most flexible type for arbitrary data.
• For the NUMERIC and DECIMAL types, Decimal(p, s) in Tinybird requires specifying precision (p) and scale (s).
• Time zone support in Tinybird's DateTime can be managed via additional functions or by ensuring consistent storage and retrieval time zones.
• Some types like INTERVAL don't have a direct equivalent in Tinybird and are usually stored as String or decomposed into separate fields.

See also¶

• Table functions
• Copy pipes