PostgreSQL: Documentation: 12: 51.90. pg

Documentation → PostgreSQL 12

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

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
`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.90. pg_tables

51.90. `pg_tables`