HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

PG_TABLES

PG_TABLES provides access to each table in the database.

Table 1 PG_TABLES columns

Name Type Reference Description
schemaname name PG_NAMESPACE.nspname Name of the schema that contains a table
tablename name PG_CLASS.relname Table name
tableowner name pg_get_userbyid(PG_CLASS.relowner) Table owner
tablespace name PG_TABLESPACE.spcname Tablespace that contains the table (default value:null)
hasindexes Boolean PG_CLASS.relhasindex The value is true if the table has (or recently had) an index; otherwise, the value is false.
hasrules Boolean PG_CLASS.relhasruls The value is true if the table has rules; otherwise, the value is false.
hastriggers Boolean PG_CLASS.RELHASTRIGGERS The value is TRUE if the table has triggers; otherwise, the value is FALSE.
tablecreator name pg_get_userbyid(po.creator) Table creator.
created timestamp with time zone pg_object.ctime Creation time of the object
last_ddl_time timestamp with time zone pg_object.mtime Last modification time of the object
Copyright © 2011-2024 www.enmotech.com All rights reserved.