PG_TABLES
PG_TABLES displays access to each table in the database.
Name |
Type |
Reference |
Description |
---|---|---|---|
schemaname |
name |
PG_NAMESPACE.nspname |
Name of the schema that contains the table |
tablename |
name |
PG_CLASS.relname |
Name of the table |
tableowner |
name |
pg_get_userbyid(PG_CLASS.relowner) |
Owner of the table |
tablespace |
name |
PG_TABLESPACE.spcname |
Tablespace that contains the table. The default value is null |
hasindexes |
boolean |
PG_CLASS.relhasindex |
Whether the table has (or recently had) an index. If it does, its value is true. Otherwise, its value is false. |
hasrules |
boolean |
PG_CLASS.relhasrules |
Whether the table has rules. If it does, its value is true. Otherwise, its value is false. |
hastriggers |
boolean |
PG_CLASS.RELHASTRIGGERS |
Whether the table has triggers. If it does, its value is true. Otherwise, its value is false. |
tablecreator |
name |
pg_get_userbyid(PG_OBJECT.creator) |
Table creator. If the creator has been deleted, no value is returned. |
created |
timestamp with time zone |
PG_OBJECT.ctime |
Time when the table was created. |
last_ddl_time |
timestamp with time zone |
PG_OBJECT.mtime |
Last time when the cluster was modified. |
Example
Query all tables in a specified schema.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.