Postgres Adapter

The Postgres adapter lets you connect to Altertable through the PostgreSQL wire protocol. It works with BI tools and SQL clients that already speak Postgres.

This adapter is ideal for:

• BI tools like Hex, Looker, Tableau, Power BI, and Metabase
• SQL clients such as DBeaver and pgAdmin

Authentication

Use your Altertable username and password with TLS enabled.

SQL Dialect

While the connection uses the Postgres protocol, queries are executed using DuckDB SQL dialect. This means that Postgres-specific functions (e.g., string_agg, generate_series) may not work.

Quick Start

Postgres

Copy

1

2

3

4

5

-- Altertable speaks the Postgres wire protocol natively.
-- No SDK needed — any Postgres client works out of the box.

-- psql
psql "postgresql://your_username:[email protected]:443/my_db"

Connection examples

psql

Copy
PGSSLMODE=require psql -h postgres.altertable.ai -p 443 -U your_username your_database

Python (psycopg2)

Copy
1
2
3
4
5
6
7
8
9
import psycopg2

conn = psycopg2.connect(
    host="postgres.altertable.ai",
    port=443,
    database="your_database",
    user="your_username",
    password="your_password"
)