PostgreSQL

51.90. `pg_tables`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.90. `pg_tables`

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

Table 51.91. pg_tables Columns

Name Type References Description

Name	Type	References	Description
`schemaname`	`name`	`pg_namespace.nspname`	Name of schema containing table
`tablename`	`name`	`pg_class.relname`	Name of table
`tableowner`	`name`	`pg_authid.rolname`	Name of table’s owner
`tablespace`	`name`	`pg_tablespace.spcname`	Name of tablespace containing table (null if default for database)
`hasindexes`	`boolean`	`pg_class.relhasindex`	True if table has (or recently had) any indexes
`hasrules`	`boolean`	`pg_class.relhasrules`	True if table has (or once had) rules
`hastriggers`	`boolean`	`pg_class.relhastriggers`	True if table has (or once had) triggers
`rowsecurity`	`boolean`	`pg_class.relrowsecurity`	True if row security is enabled on the table

schemaname

name

pg_namespace.nspname

Name of schema containing table

tablename

name

pg_class.relname

Name of table

tableowner

name

pg_authid.rolname

Name of table’s owner

tablespace

name

pg_tablespace.spcname

Name of tablespace containing table (null if default for database)

hasindexes

boolean

pg_class.relhasindex

True if table has (or recently had) any indexes

hasrules

boolean

pg_class.relhasrules

True if table has (or once had) rules

hastriggers

boolean

pg_class.relhastriggers

True if table has (or once had) triggers

rowsecurity

boolean

pg_class.relrowsecurity

True if row security is enabled on the table

Prev	Up	Next
51.89. `pg_stats_ext`	Home	51.91. `pg_timezone_abbrevs`

51.89. pg_stats_ext

Home

51.91. pg_timezone_abbrevs

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

51.90. pg_tables

Submit correction

51.90. `pg_tables`