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.relhasruls |
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot