pg_opclass
pg_opclass
Properties| Property | Value | Property | Value | |
|---|---|---|---|---|
| OID | 16802 | Total size | 8.0 KB | |
| Owner | postgres | Table size | 0 bytes | |
| Tablespace | pg_default | Indexes size | 8.0 KB | |
| Primary key(s) | Toast size | 0 bytes | ||
| Estimated rows | 0 | |||
| Comment | ||||
Columns - 8| Name | Type | Length | Default value | Allow null | Unique | Comment |
|---|---|---|---|---|---|---|
| opcmethod | oid | false | false | |||
| opcname | name | false | false | |||
| opcnamespace | oid | false | false | |||
| opcowner | oid | false | false | |||
| opcfamily | oid | false | false | |||
| opcintype | oid | false | false | |||
| opcdefault | boolean | false | false | |||
| opckeytype | oid | false | false |
Indexes - 1| Name | Primary | Unique | Clustered | Size | Definition |
|---|---|---|---|---|---|
| pg_opclass_pkey | true | true | false | 8.0 KB | btree (oid) |
Foreign keys - 6| Name | Keys | Reference table | Reference keys | Match type | Delete type | Update type |
|---|---|---|---|---|---|---|
| pg_opclass_opcnamespace_fkey | opcnamespace | pg_namespace | no action | no action | ||
| pg_opclass_opckeytype_fkey | opckeytype | pg_type | no action | no action | ||
| pg_opclass_opcintype_fkey | opcintype | pg_type | no action | no action | ||
| pg_opclass_opcfamily_fkey | opcfamily | pg_opfamily | no action | no action | ||
| pg_opclass_opcowner_fkey | opcowner | pg_authid | no action | no action | ||
| pg_opclass_opcmethod_fkey | opcmethod | pg_am | no action | no action |