50.78. pg_tables

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

Table 50-79. 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		Next
`pg_stats`	Up	`pg_timezone_abbrevs`

© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/view-pg-tables.html