Schema Objects

Every PostgreSQL object type DPG can declare, with the DPG source and generated SQL for each.
SectionObjects
Schemas & ExtensionsSCHEMA, EXTENSION
TypesENUM, composite, range, domain, virtual, base
TablesColumns, constraints, indexes, RLS, triggers, partitioning
ViewsRegular, materialized, recursive
FunctionsSQL/PL, attributes, procedures, aggregates
SequencesSEQUENCE
Schemas & Extensions

SCHEMA and EXTENSION declarations.

Types

ENUM, composite, range, domain, virtual, and base type declarations.

Tables

Table declarations including columns, constraints, indexes, RLS, triggers, and partitioning.

Views

Regular, materialized, and recursive view declarations.

Functions

SQL and PL/pgSQL functions, function attributes, procedures, and aggregate functions.

Sequences

SEQUENCE declarations with AS, START, INCREMENT, MINVALUE, MAXVALUE, CACHE, CYCLE, and OWNED BY.