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 |
|
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 (or once had) rules |
hastriggers |
boolean |
|
True if table has (or once had) triggers |
rowsecurity |
boolean |
|
True if row security is enabled on the table |
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.