52.90. pg_tables

52.90. `pg_tables`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.90. `pg_tables`

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

Table 52.91. pg_tables Columns

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

Prev	Up	Next
52.89. `pg_stats_ext`	Home	52.91. `pg_timezone_abbrevs`