PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_tables

Read PG 18 manual ↗

The view pg_tables provides access to useful information about each table in the database.

Kind: System views
Columns in this snapshot: 8
Definition source: English manual

Columns 8

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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tableowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`hasindexes`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`hasrules`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`hastriggers`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rowsecurity`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 1

PG 9.4 → 9.5changed

Definition snapshot: english-manuals:db1123581b44b836a4b07ede225… · English manual source