54.30. pg_tables

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

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