Advanced Objects

Full-text search, logical replication, event triggers, collations, operators, casts, statistics, foreign data, and tablespaces.
PageObjects
Full-Text SearchTEXT SEARCH CONFIGURATION, DICTIONARY, PARSER, TEMPLATE
Logical ReplicationPUBLICATION, SUBSCRIPTION
Event TriggersEVENT TRIGGER
CollationsCOLLATION
OperatorsOPERATOR, OPERATOR CLASS, OPERATOR FAMILY
CastsCAST
StatisticsSTATISTICS objects
Foreign DataFOREIGN DATA WRAPPER, SERVER, USER MAPPING, FOREIGN TABLE
TablespacesTABLESPACE

Full-Text Search

TEXT SEARCH CONFIGURATION, DICTIONARY, PARSER, and TEMPLATE declarations.

Logical Replication

PUBLICATION and SUBSCRIPTION declarations.

Event Triggers

EVENT TRIGGER declarations that fire on DDL events.

Collations

COLLATION declarations with provider, locale, and determinism.

Operators

OPERATOR, OPERATOR CLASS, and OPERATOR FAMILY declarations.

Casts

CAST declarations with function, implicit, assignment, and explicit cast contexts.

Statistics Objects

Extended statistics objects for multi-column correlation tracking.

Foreign Data

FOREIGN DATA WRAPPER, SERVER, USER MAPPING, and FOREIGN TABLE declarations.

Tablespaces

TABLESPACE declarations — cluster-level objects that map a name to a filesystem location.