PostgreSQL

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

51.88. `pg_tables`

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

Table 51.89. 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

Name of schema containing table

tablename

name

Name of table

tableowner

name

Name of table’s owner

tablespace

name

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.87. `pg_stats`	Home	51.89. `pg_timezone_abbrevs`

51.87. pg_stats

51.89. pg_timezone_abbrevs