pg_aggregate
pg_aggregate
Properties| Property | Value | Property | Value | |
|---|---|---|---|---|
| OID | 16643 | Total size | 8.0 KB | |
| Owner | postgres | Table size | 0 bytes | |
| Tablespace | pg_default | Indexes size | 0 bytes | |
| Primary key(s) | Toast size | 8.0 KB | ||
| Estimated rows | 0 | |||
| Comment | ||||
Columns - 20| Name | Type | Length | Default value | Allow null | Unique | Comment |
|---|---|---|---|---|---|---|
| aggfnoid | regproc | false | false | |||
| aggkind | "char" | false | false | |||
| aggnumdirectargs | smallint | false | false | |||
| aggtransfn | regproc | false | false | |||
| aggfinalfn | regproc | false | false | |||
| aggcombinefn | regproc | false | false | |||
| aggserialfn | regproc | false | false | |||
| aggdeserialfn | regproc | false | false | |||
| aggmtransfn | regproc | false | false | |||
| aggminvtransfn | regproc | false | false | |||
| aggmfinalfn | regproc | false | false | |||
| aggfinalextra | boolean | false | false | |||
| aggmfinalextra | boolean | false | false | |||
| aggsortop | oid | false | false | |||
| aggtranstype | oid | false | false | |||
| aggtransspace | integer | false | false | |||
| aggmtranstype | oid | false | false | |||
| aggmtransspace | integer | false | false | |||
| agginitval | text | true | false | |||
| aggminitval | text | true | false |
Foreign keys - 12| Name | Keys | Reference table | Reference keys | Match type | Delete type | Update type |
|---|---|---|---|---|---|---|
| pg_aggregate_aggtransfn_fkey | aggtransfn | pg_proc | no action | no action | ||
| pg_aggregate_aggsortop_fkey | aggsortop | pg_operator | no action | no action | ||
| pg_aggregate_aggserialfn_fkey | aggserialfn | pg_proc | no action | no action | ||
| pg_aggregate_aggmtranstype_fkey | aggmtranstype | pg_type | no action | no action | ||
| pg_aggregate_aggtranstype_fkey | aggtranstype | pg_type | no action | no action | ||
| pg_aggregate_aggmtransfn_fkey | aggmtransfn | pg_proc | no action | no action | ||
| pg_aggregate_aggminvtransfn_fkey | aggminvtransfn | pg_proc | no action | no action | ||
| pg_aggregate_aggmfinalfn_fkey | aggmfinalfn | pg_proc | no action | no action | ||
| pg_aggregate_aggfnoid_fkey | aggfnoid | pg_proc | no action | no action | ||
| pg_aggregate_aggfinalfn_fkey | aggfinalfn | pg_proc | no action | no action | ||
| pg_aggregate_aggdeserialfn_fkey | aggdeserialfn | pg_proc | no action | no action | ||
| pg_aggregate_aggcombinefn_fkey | aggcombinefn | pg_proc | no action | no action |