Supported Versions: Current (12) / 11 / 10 / 9.6 / 9.5
Development Versions: 13 / devel
Unsupported versions: 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 supported versions listed above instead.

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

Column Type

Description

schemaname name (references pg_namespace.nspname)

Name of schema containing table

tablename name (references pg_class.relname)

Name of table

tableowner name (references pg_authid.rolname)

Name of table's owner

tablespace name (references pg_tablespace.spcname)

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

hasindexes bool (references pg_class.relhasindex)

True if table has (or recently had) any indexes

hasrules bool (references pg_class.relhasrules)

True if table has (or once had) rules

hastriggers bool (references pg_class.relhastriggers)

True if table has (or once had) triggers

rowsecurity bool (references pg_class.relrowsecurity)

True if row security is enabled on the table