pg_class
Properties| Property | Value | Property | Value | |
|---|---|---|---|---|
| OID | 16682 | Total size | 16.0 KB | |
| Owner | postgres | Table size | 0 bytes | |
| Tablespace | pg_default | Indexes size | 8.0 KB | |
| Primary key(s) | Toast size | 8.0 KB | ||
| Estimated rows | 0 | |||
| Comment | ||||
Columns - 33| Name | Type | Length | Default value | Allow null | Unique | Comment |
|---|---|---|---|---|---|---|
| relname | name | false | false | |||
| relnamespace | oid | false | false | |||
| reltype | oid | false | false | |||
| reloftype | oid | false | false | |||
| relowner | oid | false | false | |||
| relam | oid | false | false | |||
| relfilenode | oid | false | false | |||
| reltablespace | oid | false | false | |||
| relpages | integer | false | false | |||
| reltuples | real | false | false | |||
| relallvisible | integer | false | false | |||
| reltoastrelid | oid | false | false | |||
| relhasindex | boolean | false | false | |||
| relisshared | boolean | false | false | |||
| relpersistence | "char" | false | false | |||
| relkind | "char" | false | false | |||
| relnatts | smallint | false | false | |||
| relchecks | smallint | false | false | |||
| relhasoids | boolean | false | false | |||
| relhaspkey | boolean | false | false | |||
| relhasrules | boolean | false | false | |||
| relhastriggers | boolean | false | false | |||
| relhassubclass | boolean | false | false | |||
| relrowsecurity | boolean | false | false | |||
| relforcerowsecurity | boolean | false | false | |||
| relispopulated | boolean | false | false | |||
| relreplident | "char" | false | false | |||
| relispartition | boolean | false | false | |||
| relfrozenxid | xid | false | false | |||
| relminmxid | xid | false | false | |||
| relacl | aclitem[] | true | false | |||
| reloptions | text[] | true | false | |||
| relpartbound | pg_node_tree | true | false |
Indexes - 1| Name | Primary | Unique | Clustered | Size | Definition |
|---|---|---|---|---|---|
| pg_class_pkey | true | true | false | 8.0 KB | btree (oid) |
Foreign keys - 7| Name | Keys | Reference table | Reference keys | Match type | Delete type | Update type |
|---|---|---|---|---|---|---|
| pg_class_relam_fkey | relam | pg_am | no action | no action | ||
| pg_class_reloftype_fkey | reloftype | pg_type | no action | no action | ||
| pg_class_relnamespace_fkey | relnamespace | pg_namespace | no action | no action | ||
| pg_class_reltype_fkey | reltype | pg_type | no action | no action | ||
| pg_class_reltoastrelid_fkey | reltoastrelid | pg_class | no action | no action | ||
| pg_class_reltablespace_fkey | reltablespace | pg_tablespace | no action | no action | ||
| pg_class_relowner_fkey | relowner | pg_authid | no action | no action |
| Author: DB Doc | Copyright 2014 - 2017 All Rights Reserved | Created on Jun 12, 2017 2:27 AM |