Publication¶

A publication is essentially a group of tables whose data changes are intended to be replicated through logical replication.

Properties¶

Property	Type	Required	Description
`name`	`string`	yes	The name of the publication to create.
`tables`	array of (`string` \| `object`)	—	The tables to publish, each exactly the table named: an inheritance child is listed on its own, as pg_dump writes it. A table is its qualified name, or an object that also limits the columns or rows published. Minimum items: `1`.
`schemas`	array of `string`	—	Publish every table in these schemas, including tables created later (FOR TABLES IN SCHEMA). Minimum items: `1`.
`all_tables`	`boolean`	—	Use to replicate all tables.
`parameters`	`object`	—	Publication Parameters.
`comment`	`string`	—	An optional comment about the publication.

Property	Type	Required	Description
`publish`	array of (`insert` \| `update` \| `delete` \| `truncate`)	—	This parameter determines which DML operations will be published by the new publication to the subscribers.
`publish_via_partition_root`	`boolean`	—	Publish changes to a partition as changes to its partitioned root table.
`publish_generated_columns`	`none` \| `stored`	—	Whether stored generated columns are published (PostgreSQL 18).

No other properties are accepted.