pg_attribute

Properties
Property Value    Property Value
OID16664Total size16.0 KB
OwnerpostgresTable size0 bytes
Tablespacepg_defaultIndexes size8.0 KB
Primary key(s)attrelid, attnumToast size8.0 KB
Estimated rows0
Comment
Columns - 27
Name Type Length Default value Allow null Unique Comment
attrelid oid false false
attname name false false
atttypid oid false false
attstattarget integer false false
attlen smallint false false
attnum smallint false false
attndims integer false false
attcacheoff integer false false
atttypmod integer false false
attbyval boolean false false
attstorage "char" false false
attalign "char" false false
attnotnull boolean false false
atthasdef boolean false false
attidentity "char" false false
attisdropped boolean false false
attislocal boolean false false
attinhcount integer false false
attislocal boolean false false
attcollation oid false false
attinhcount integer false false
attcollation oid false false
attacl aclitem[] true false
attoptions text[] true false
attacl aclitem[] true false
attoptions text[] true false
attfdwoptions text[] true false
Indexes - 1
Name Primary Unique Clustered Size Definition
pg_attribute_pkey true true false 8.0 KB
btree (attrelid, att... (Documents created using the DB Doc trial version displays only the first 20 characters of the definition.  To display the complete definition, please purchase a license from www.yohz.com/store.htm.)
Foreign keys - 3
Name Keys Reference table Reference keys Match type Delete type Update type
pg_attribute_attrelid_fkey attrelid pg_class no action no action
pg_attribute_atttypid_fkey atttypid pg_type no action no action
pg_attribute_attcollation_fkey attislocal pg_collation no action no action