The view pg_tables
provides access to
useful information about each table in the database.
Table 43.47. pg_tables
Columns
Name | Type | References | Description |
---|---|---|---|
schemaname |
name |
|
Name of schema containing table |
tablename |
name |
|
Name of table |
tableowner |
name |
|
Name of table's owner |
tablespace |
name |
|
Name of tablespace containing table (NULL if default for database) |
hasindexes |
boolean |
|
true if table has (or recently had) any indexes |
hasrules |
boolean |
|
true if table has rules |
hastriggers |
boolean |
|
true if table has triggers |