All pages
Powered by GitBook
1 of 1

Loading...

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

hasindexes

boolean

.relhasindex

True if table has (or recently had) any indexes

hasrules

boolean

.relhasrules

True if table has (or once had) rules

hastriggers

boolean

.relhastriggers

True if table has (or once had) triggers

rowsecurity

boolean

.relrowsecurity

True if row security is enabled on the table

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)

pg_class
pg_class
pg_class
pg_class