pg_kalam 0.4.2-rc.3 SQL Syntax

This archive lists the primary SQL shapes for pg_kalam in 0.4.2-rc.3.

Create The Foreign Server

1CREATE SERVER IF NOT EXISTS kalam_server2  FOREIGN DATA WRAPPER pg_kalam3  OPTIONS (4    host '127.0.0.1',5    port '9188',6    auth_header 'Bearer <token>'7  );

Create A KalamDB Table From PostgreSQL

1CREATE TABLE app.items (2  id BIGINT PRIMARY KEY DEFAULT SNOWFLAKE_ID(),3  title TEXT NOT NULL4) USING kalamdb WITH (5  type = 'shared'6);

Query

1SELECT id, title2FROM app.items3ORDER BY id;

Notes

• Point port at the KalamDB RPC listener.
• Keep the primary key as the first user column when update and delete behavior matters.
• Use the latest pg_kalam docs when you are not pinned to this archive.