DB9 implements PostgreSQL-compatible system catalog views for introspecting database objects.
| View | Description |
|---|
pg_tables | User tables |
pg_views | User views |
pg_class | Tables, indexes, sequences, views |
pg_attribute | Table columns |
pg_attrdef | Column default values |
pg_namespace | Schemas |
pg_type | Data types |
pg_index | Index metadata |
pg_constraint | Constraints (PK, FK, CHECK, UNIQUE) |
pg_proc | Functions and procedures |
pg_trigger | Triggers |
pg_enum | Enum type values |
pg_sequence | Sequence metadata |
pg_extension | Installed extensions |
pg_collation | Collations |
pg_roles / pg_user | User and role definitions |
pg_database | Databases |
pg_description | Object descriptions/comments |
pg_depend | Dependency tracking |
pg_am | Access methods |
pg_stat_user_tables | Table statistics |
pg_inherits | Table inheritance |
pg_range | Range type metadata |
pg_opclass | Operator classes |
pg_policy | Row-level security policies |
| View | Description |
|---|
tables | Tables |
columns | Table columns (includes is_generated, generation_expression) |
schemata | Schemas |
sequences | Sequences |
routines | Functions and procedures |
table_constraints | All table constraints |
key_column_usage | PRIMARY/FOREIGN KEY columns |
referential_constraints | Foreign key constraints |
check_constraints | CHECK constraints |
constraint_column_usage | Column constraint usage |
table_privileges | Table access privileges |
| View | Description |
|---|
cron.job | Scheduled cron jobs |
cron.job_run_details | Job execution history |