pg_proc
Properties| Property | Value | Property | Value | |
|---|---|---|---|---|
| OID | 16829 | 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 - 29| Name | Type | Length | Default value | Allow null | Unique | Comment |
|---|---|---|---|---|---|---|
| proname | name | false | false | |||
| pronamespace | oid | false | false | |||
| proowner | oid | false | false | |||
| prolang | oid | false | false | |||
| procost | real | false | false | |||
| prorows | real | false | false | |||
| provariadic | oid | false | false | |||
| protransform | regproc | false | false | |||
| proisagg | boolean | false | false | |||
| proiswindow | boolean | false | false | |||
| prosecdef | boolean | false | false | |||
| proleakproof | boolean | false | false | |||
| proisstrict | boolean | false | false | |||
| proretset | boolean | false | false | |||
| provolatile | "char" | false | false | |||
| proparallel | "char" | false | false | |||
| pronargs | smallint | false | false | |||
| pronargdefaults | smallint | false | false | |||
| prorettype | oid | false | false | |||
| proargtypes | oidvector | false | false | |||
| proallargtypes | oid[] | true | false | |||
| proargmodes | "char"[] | true | false | |||
| proargnames | text[] | true | false | |||
| proargdefaults | pg_node_tree | true | false | |||
| protrftypes | oid[] | true | false | |||
| prosrc | text | false | false | |||
| probin | text | true | false | |||
| proconfig | text[] | true | false | |||
| proacl | aclitem[] | true | false |
Indexes - 1| Name | Primary | Unique | Clustered | Size | Definition |
|---|---|---|---|---|---|
| pg_proc_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_proc_proowner_fkey | proowner | pg_authid | no action | no action | ||
| pg_proc_prolang_fkey | prolang | pg_language | no action | no action | ||
| pg_proc_protransform_fkey | protransform | pg_type | no action | no action | ||
| pg_proc_prorettype_fkey | prorettype | pg_type | no action | no action | ||
| pg_proc_pronamespace_fkey | pronamespace | pg_namespace | no action | no action | ||
| pg_proc_provariadic_fkey | provariadic | pg_type | no action | no action |
| Author: DB Doc | Copyright 2014 - 2017 All Rights Reserved | Created on Jun 12, 2017 2:27 AM |