Supported Objects

Supported Objects

The engine covers 50+ PostgreSQL object types with 190+ properties tracked.

---

Track 1: Structural Objects

Table

Property	Status
schema	✅
name	✅
columns	✅
constraints	✅
indexes	✅
triggers	✅
comment	✅
inherits	✅
partition_by	✅
partition_key	✅
partition_default	✅
partition_columns	✅
toast	✅
fillfactor	✅
parallel_workers	✅
options	✅
oids	✅
access_method	✅
reloptions	✅
check_option	✅
security_barrier	✅
security_invoker	✅
owner	✅
privileges	✅
policies	✅
relkind	✅
relpersistence	✅
relispartition	✅
relfrozenxid	✅
relminmxid	✅

Column

Property	Status
name	✅
dataType	✅
isNullable	✅
defaultValue	✅
isPrimaryKey	✅
comment	✅
isGenerated	✅
generationExpr	✅
isIdentity	✅
identityOptions	✅
collation	✅
storage	✅
statistics	✅
attnum	✅
attlen	✅
attalign	✅
attstorage	✅
attbyval	✅
attndims	✅
atttypmod	✅
atthasdef	✅
atthasmissing	✅
attidentity	✅
attgenerated	✅
attisdropped	✅
attislocal	✅
attinhcount	✅
attnotnull	✅

Index

Property	Status
schema	✅
name	✅
tableName	✅
columns	✅
unique	✅
primary	✅
type	✅
where	✅
comment	✅
isUnique	✅
isPrimary	✅
isConcurrent	✅
isValid	✅
isReady	✅
indexdef	✅
indisvalid	✅
indisready	✅
indislive	✅
indisreplident	✅
indimmediate	✅
indexrelid	✅
indrelid	✅
indnatts	✅
indnkeyatts	✅
indoption	✅
indcollation	✅

Constraint

Property	Status
name	✅
type	✅
schema	✅
tableName	✅
columns	✅
referencedSchema	✅
referencedTable	✅
referencedColumns	✅
onUpdate	✅
onDelete	✅
match	✅
deferrable	✅
deferred	✅
validated	✅
definition	✅
convalidated	✅
condeferred	✅
confdeltype	✅
confupdtype	✅
confmatchtype	✅

Sequence

Property	Status
schema	✅
name	✅
start	✅
increment	✅
minvalue	✅
maxvalue	✅
cache	✅
cycle	✅
ownedBy	✅
owner	✅
privileges	✅
lastValue	✅
isCalled	✅
dataType	✅

Enum Type

Property	Status
schema	✅
name	✅
values	✅
owner	✅
privileges	✅
comment	✅
typnamespace	✅
typowner	✅
typcategory	✅

Composite Type

Property	Status
schema	✅
name	✅
attributes	✅
owner	✅
privileges	✅
comment	✅
typnamespace	✅
typowner	✅
typcategory	✅
typinput	✅

Domain Type

Property	Status
schema	✅
name	✅
baseType	✅
notNull	✅
defaultValue	✅
check	✅
owner	✅
privileges	✅
comment	✅
typnamespace	✅
typowner	✅
typcategory	✅
typnotnull	✅
typdefault	✅
typbasetype	✅
typtypmod	✅

Range Type

Property	Status
schema	✅
name	✅
subtype	✅
canonical	✅
subtypeDiff	✅
owner	✅
privileges	✅
rngsubtype	✅
rngcanonical	✅
rngsubtypediff	✅

Schema

Property	Status
name	✅
owner	✅
privileges	✅
comment	✅
nspowner	✅

Extension

Property	Status
name	✅
schema	✅
version	✅
relocatable	✅
extnamespace	✅
extrelocatable	✅
extversion	✅

Statistics

Property	Status
schema	✅
name	✅
tableName	✅
columns	✅
kinds	✅
owner	✅
privileges	✅
comment	✅
stxrelid	✅

Partition

Property	Status
parentSchema	✅
parentTable	✅
childSchema	✅
childTable	✅
parttype	✅
partattrs	✅

Collation

Property	Status
schema	✅
name	✅
locale	✅
provider	✅
deterministic	✅
owner	✅
privileges	✅
comment	✅
collnamespace	✅
collencoding	✅

Cast

Property	Status
sourceType	✅
targetType	✅
function	✅
context	✅
method	✅

Operator / OpClass / OpFamily

Full coverage.

Access Method

Property	Status
name	✅
type	✅
handler	✅

Foreign Table

Property	Status
schema	✅
name	✅
server	✅
columns	✅
options	✅

Default Privileges

Property	Status
role	✅
schema	✅
objectType	✅
privileges	✅

---

Track 2: Behavioral Objects

View

Property	Status
schema	✅
name	✅
definition	✅
columns	✅
checkOption	✅
securityBarrier	✅
securityInvoker	✅
owner	✅
privileges	✅
comment	✅

Materialized View

Property	Status
schema	✅
name	✅
definition	✅
columns	✅
storage	✅
withData	✅
owner	✅
privileges	✅
comment	✅
isPopulated	✅

Function

Property	Status
schema	✅
name	✅
arguments	✅
returnType	✅
language	✅
body	✅
volatility	✅
strict	✅
securityDefiner	✅
cost	✅
rows	✅
owner	✅
privileges	✅
comment	✅

Procedure

Same as Function, plus transaction control support.

Aggregate

Property	Status
schema	✅
name	✅
arguments	✅
sfunc	✅
stype	✅
sspace	✅
finalfunc	✅
finalfunc_extra	✅
finalfunc_modify	✅
combinefunc	✅
serialfunc	✅
deserialfunc	✅
initcond	✅
msfunc	✅
minvfunc	✅
mstype	✅
msspace	✅
mfinalfunc	✅
minitcond	✅
sortop	✅
owner	✅

Trigger

Property	Status
schema	✅
name	✅
tableName	✅
eventName	✅
timing	✅
orientation	✅
forEach	✅
function	✅
columns	✅
whenCondition	✅
enabled	✅
comment	✅

Event Trigger

Property	Status
name	✅
eventName	✅
function	✅
filter	✅
enabled	✅
comment	✅

Policy

Property	Status
schema	✅
name	✅
tableName	✅
command	✅
roles	✅
using	✅
withCheck	✅
permissive	✅
comment	✅

Rule

Property	Status
schema	✅
name	✅
tableName	✅
event	✅
instead	✅
condition	✅
commands	✅
comment	✅

Text Search

All objects covered: Config, Dictionary, Parser, Template.

Conversion

Property	Status
schema	✅
name	✅
sourceEncoding	✅
destEncoding	✅
function	✅
default	✅
owner	✅

Foreign Data Wrapper

Property	Status
name	✅
handler	✅
validator	✅
options	✅
owner	✅

Foreign Server

Property	Status
name	✅
fdw	✅
version	✅
options	✅
owner	✅

User Mapping

Property	Status
server	✅
user	✅
options	✅

Publication

Property	Status
name	✅
tables	✅
allTables	✅
insert	✅
update	✅
delete	✅
truncate	✅
owner	✅

Subscription

Property	Status
name	✅
conninfo	✅
publications	✅
enabled	✅
slotName	✅
syncCommit	✅
owner	✅

---

Summary

Track	Objects
Track 1 (Structural)	19+
Track 2 (Behavioral)	18+
Total	50+

---

See Also

• Architecture — How these are introspected and processed
• API-Reference — Accessing these via code
• PG-Version-Matrix — Version-specific feature support