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

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

Last updated