System Catalogs / System views
pg_tables
Read the PG 18 manualThe view pg_tables provides access to useful information about each table in the database.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System views
- Columns in this snapshot
- 8
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 8
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
schemaname | name | Name of schema containing table pg_namespace.nspname |
tablename | name | Name of table pg_class.relname |
tableowner | name | Name of table's owner pg_authid.rolname |
tablespace | name | Name of tablespace containing table (null if default for database) pg_tablespace.spcname |
hasindexes | bool | True if table has (or recently had) any indexes pg_class.relhasindex |
hasrules | bool | True if table has (or once had) rules pg_class.relhasrules |
hastriggers | bool | True if table has (or once had) triggers pg_class.relhastriggers |
rowsecurity | bool | True if row security is enabled on the table pg_class.relrowsecurity |
Column history across versions
Version history 5
Definition snapshot: english-manuals:d3b90a4fcb70a6992ea31eb4d6a… · English manual source