The view pg_tables provides access to useful information about each table in the database.
Table 42-44. 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
|
pg_tablespace
.spcname
|
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 rules |
|
hastriggers
|
boolean
|
pg_class
.reltriggers
|
true if table has triggers |
