Interface ForeignTableOptions

Options for CREATE FOREIGN TABLE

interface ForeignTableOptions {
    serverName: string;
    schema?: string;
    columns: Record<string, ForeignTableColumnDef>;
    options?: Record<string, string>;
    ifNotExists?: boolean;
}

Properties

serverName: string

The foreign server that provides this table

schema?: string

Optional local schema to create the table in

columns: Record<string, ForeignTableColumnDef>

Column definitions keyed by column name

options?: Record<string, string>

Table-level OPTIONS

ifNotExists?: boolean

Use CREATE FOREIGN TABLE IF NOT EXISTS