The view pg_tables provides access to useful information about each table in the database.
pg_tables Columnsschemaname
name
.nspname
Name of schema containing table
tablename
name
.relname
Name of table
tableowner
name
.rolname
Name of table's owner
tablespace
name
.spcname
Name of tablespace containing table (null if default for database)
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