tmp
Tables (50)
pg_aggregate
- aggfnoid — regproc — NOT NULL
- aggkind — "char" — NOT NULL
- aggnumdirectargs — smallint — NOT NULL
- aggtransfn — regproc — NOT NULL
- aggfinalfn — regproc — NOT NULL
- aggcombinefn — regproc — NOT NULL
- aggserialfn — regproc — NOT NULL
- aggdeserialfn — regproc — NOT NULL
- aggmtransfn — regproc — NOT NULL
- aggminvtransfn — regproc — NOT NULL
- aggmfinalfn — regproc — NOT NULL
- aggfinalextra — boolean — NOT NULL
- aggmfinalextra — boolean — NOT NULL
- aggfinalmodify — "char" — NOT NULL
- aggmfinalmodify — "char" — NOT NULL
- aggsortop — oid — NOT NULL
- aggtranstype — oid — NOT NULL
- aggtransspace — integer — NOT NULL
- aggmtranstype — oid — NOT NULL
- aggmtransspace — integer — NOT NULL
- agginitval — text
- aggminitval — text
pg_am
- oid — oid — NOT NULL
- amname — information_schema.sql_identifier — NOT NULL
- amhandler — regproc — NOT NULL
- amtype — "char" — NOT NULL
pg_amop
- oid — oid — NOT NULL
- amopfamily — oid — NOT NULL
- amoplefttype — oid — NOT NULL
- amoprighttype — oid — NOT NULL
- amopstrategy — smallint — NOT NULL
- amoppurpose — "char" — NOT NULL
- amopopr — oid — NOT NULL
- amopmethod — oid — NOT NULL
- amopsortfamily — oid — NOT NULL
pg_amproc
- oid — oid — NOT NULL
- amprocfamily — oid — NOT NULL
- amproclefttype — oid — NOT NULL
- amprocrighttype — oid — NOT NULL
- amprocnum — smallint — NOT NULL
- amproc — regproc — NOT NULL
pg_attrdef
- oid — oid — NOT NULL
- adrelid — oid — NOT NULL
- adnum — smallint — NOT NULL
- adbin — pg_node_tree — NOT NULL
pg_attribute
- attrelid — oid — NOT NULL
- attname — information_schema.sql_identifier — NOT NULL
- atttypid — oid — NOT NULL
- attstattarget — integer — NOT NULL
- attlen — smallint — NOT NULL
- attnum — smallint — NOT NULL
- attndims — integer — NOT NULL
- attcacheoff — integer — NOT NULL
- atttypmod — integer — NOT NULL
- attbyval — boolean — NOT NULL
- attalign — "char" — NOT NULL
- attstorage — "char" — NOT NULL
- attcompression — "char" — NOT NULL
- attnotnull — boolean — NOT NULL
- atthasdef — boolean — NOT NULL
- atthasmissing — boolean — NOT NULL
- attidentity — "char" — NOT NULL
- attgenerated — "char" — NOT NULL
- attisdropped — boolean — NOT NULL
- attislocal — boolean — NOT NULL
- attinhcount — integer — NOT NULL
- attcollation — oid — NOT NULL
- attacl — aclitem
- attoptions — text
- attfdwoptions — text
- attmissingval — anyarray
pg_auth_members
- roleid — oid — NOT NULL
- member — oid — NOT NULL
- grantor — oid — NOT NULL
- admin_option — boolean — NOT NULL
pg_authid
- oid — oid — NOT NULL
- rolname — information_schema.sql_identifier — NOT NULL
- rolsuper — boolean — NOT NULL
- rolinherit — boolean — NOT NULL
- rolcreaterole — boolean — NOT NULL
- rolcreatedb — boolean — NOT NULL
- rolcanlogin — boolean — NOT NULL
- rolreplication — boolean — NOT NULL
- rolbypassrls — boolean — NOT NULL
- rolconnlimit — integer — NOT NULL
- rolpassword — text
- rolvaliduntil — timestamp
pg_cast
- oid — oid — NOT NULL
- castsource — oid — NOT NULL
- casttarget — oid — NOT NULL
- castfunc — oid — NOT NULL
- castcontext — "char" — NOT NULL
- castmethod — "char" — NOT NULL
pg_class
- oid — oid — NOT NULL
- relname — information_schema.sql_identifier — NOT NULL
- relnamespace — oid — NOT NULL
- reltype — oid — NOT NULL
- reloftype — oid — NOT NULL
- relowner — oid — NOT NULL
- relam — oid — NOT NULL
- relfilenode — oid — NOT NULL
- reltablespace — oid — NOT NULL
- relpages — integer — NOT NULL
- reltuples — real — NOT NULL
- relallvisible — integer — NOT NULL
- reltoastrelid — oid — NOT NULL
- relhasindex — boolean — NOT NULL
- relisshared — boolean — NOT NULL
- relpersistence — "char" — NOT NULL
- relkind — "char" — NOT NULL
- relnatts — smallint — NOT NULL
- relchecks — smallint — NOT NULL
- relhasrules — boolean — NOT NULL
- relhastriggers — boolean — NOT NULL
- relhassubclass — boolean — NOT NULL
- relrowsecurity — boolean — NOT NULL
- relforcerowsecurity — boolean — NOT NULL
- relispopulated — boolean — NOT NULL
- relreplident — "char" — NOT NULL
- relispartition — boolean — NOT NULL
- relrewrite — oid — NOT NULL
- relfrozenxid — xid — NOT NULL
- relminmxid — xid — NOT NULL
- relacl — aclitem
- reloptions — text
- relpartbound — pg_node_tree
pg_collation
- oid — oid — NOT NULL
- collname — information_schema.sql_identifier — NOT NULL
- collnamespace — oid — NOT NULL
- collowner — oid — NOT NULL
- collprovider — "char" — NOT NULL
- collisdeterministic — boolean — NOT NULL
- collencoding — integer — NOT NULL
- collcollate — text
- collctype — text
- colliculocale — text
- collversion — text
pg_constraint
- oid — oid — NOT NULL
- conname — information_schema.sql_identifier — NOT NULL
- connamespace — oid — NOT NULL
- contype — "char" — NOT NULL
- condeferrable — boolean — NOT NULL
- condeferred — boolean — NOT NULL
- convalidated — boolean — NOT NULL
- conrelid — oid — NOT NULL
- contypid — oid — NOT NULL
- conindid — oid — NOT NULL
- conparentid — oid — NOT NULL
- confrelid — oid — NOT NULL
- confupdtype — "char" — NOT NULL
- confdeltype — "char" — NOT NULL
- confmatchtype — "char" — NOT NULL
- conislocal — boolean — NOT NULL
- coninhcount — integer — NOT NULL
- connoinherit — boolean — NOT NULL
- conkey — smallint
- confkey — smallint
- conpfeqop — oid
- conppeqop — oid
- conffeqop — oid
- confdelsetcols — smallint
- conexclop — oid
- conbin — pg_node_tree
pg_conversion
- oid — oid — NOT NULL
- conname — information_schema.sql_identifier — NOT NULL
- connamespace — oid — NOT NULL
- conowner — oid — NOT NULL
- conforencoding — integer — NOT NULL
- contoencoding — integer — NOT NULL
- conproc — regproc — NOT NULL
- condefault — boolean — NOT NULL
pg_database
- oid — oid — NOT NULL
- datname — information_schema.sql_identifier — NOT NULL
- datdba — oid — NOT NULL
- encoding — integer — NOT NULL
- datlocprovider — "char" — NOT NULL
- datistemplate — boolean — NOT NULL
- datallowconn — boolean — NOT NULL
- datconnlimit — integer — NOT NULL
- datfrozenxid — xid — NOT NULL
- datminmxid — xid — NOT NULL
- dattablespace — oid — NOT NULL
- datcollate — text — NOT NULL
- datctype — text — NOT NULL
- daticulocale — text
- datcollversion — text
- datacl — aclitem
pg_db_role_setting
- setdatabase — oid — NOT NULL
- setrole — oid — NOT NULL
- setconfig — text
pg_default_acl
- oid — oid — NOT NULL
- defaclrole — oid — NOT NULL
- defaclnamespace — oid — NOT NULL
- defaclobjtype — "char" — NOT NULL
- defaclacl — aclitem — NOT NULL
pg_depend
- classid — oid — NOT NULL
- objid — oid — NOT NULL
- objsubid — integer — NOT NULL
- refclassid — oid — NOT NULL
- refobjid — oid — NOT NULL
- refobjsubid — integer — NOT NULL
- deptype — "char" — NOT NULL
pg_description
- objoid — oid — NOT NULL
- classoid — oid — NOT NULL
- objsubid — integer — NOT NULL
- description — text — NOT NULL
pg_enum
- oid — oid — NOT NULL
- enumtypid — oid — NOT NULL
- enumsortorder — real — NOT NULL
- enumlabel — information_schema.sql_identifier — NOT NULL
pg_event_trigger
- oid — oid — NOT NULL
- evtname — information_schema.sql_identifier — NOT NULL
- evtevent — information_schema.sql_identifier — NOT NULL
- evtowner — oid — NOT NULL
- evtfoid — oid — NOT NULL
- evtenabled — "char" — NOT NULL
- evttags — text
pg_extension
- oid — oid — NOT NULL
- extname — information_schema.sql_identifier — NOT NULL
- extowner — oid — NOT NULL
- extnamespace — oid — NOT NULL
- extrelocatable — boolean — NOT NULL
- extversion — text — NOT NULL
- extconfig — oid
- extcondition — text
pg_foreign_data_wrapper
- oid — oid — NOT NULL
- fdwname — information_schema.sql_identifier — NOT NULL
- fdwowner — oid — NOT NULL
- fdwhandler — oid — NOT NULL
- fdwvalidator — oid — NOT NULL
- fdwacl — aclitem
- fdwoptions — text
pg_foreign_server
- oid — oid — NOT NULL
- srvname — information_schema.sql_identifier — NOT NULL
- srvowner — oid — NOT NULL
- srvfdw — oid — NOT NULL
- srvtype — text
- srvversion — text
- srvacl — aclitem
- srvoptions — text
pg_foreign_table
- ftrelid — oid — NOT NULL
- ftserver — oid — NOT NULL
- ftoptions — text
pg_index
- indexrelid — oid — NOT NULL
- indrelid — oid — NOT NULL
- indnatts — smallint — NOT NULL
- indnkeyatts — smallint — NOT NULL
- indisunique — boolean — NOT NULL
- indnullsnotdistinct — boolean — NOT NULL
- indisprimary — boolean — NOT NULL
- indisexclusion — boolean — NOT NULL
- indimmediate — boolean — NOT NULL
- indisclustered — boolean — NOT NULL
- indisvalid — boolean — NOT NULL
- indcheckxmin — boolean — NOT NULL
- indisready — boolean — NOT NULL
- indislive — boolean — NOT NULL
- indisreplident — boolean — NOT NULL
- indkey — int2vector — NOT NULL
- indcollation — oidvector — NOT NULL
- indclass — oidvector — NOT NULL
- indoption — int2vector — NOT NULL
- indexprs — pg_node_tree
- indpred — pg_node_tree
pg_inherits
- inhrelid — oid — NOT NULL
- inhparent — oid — NOT NULL
- inhseqno — integer — NOT NULL
- inhdetachpending — boolean — NOT NULL
pg_init_privs
- objoid — oid — NOT NULL
- classoid — oid — NOT NULL
- objsubid — integer — NOT NULL
- privtype — "char" — NOT NULL
- initprivs — aclitem — NOT NULL
pg_language
- oid — oid — NOT NULL
- lanname — information_schema.sql_identifier — NOT NULL
- lanowner — oid — NOT NULL
- lanispl — boolean — NOT NULL
- lanpltrusted — boolean — NOT NULL
- lanplcallfoid — oid — NOT NULL
- laninline — oid — NOT NULL
- lanvalidator — oid — NOT NULL
- lanacl — aclitem
pg_largeobject
- loid — oid — NOT NULL
- pageno — integer — NOT NULL
- data — bytea — NOT NULL
pg_largeobject_metadata
- oid — oid — NOT NULL
- lomowner — oid — NOT NULL
- lomacl — aclitem
pg_namespace
- oid — oid — NOT NULL
- nspname — information_schema.sql_identifier — NOT NULL
- nspowner — oid — NOT NULL
- nspacl — aclitem
pg_opclass
- oid — oid — NOT NULL
- opcmethod — oid — NOT NULL
- opcname — information_schema.sql_identifier — NOT NULL
- opcnamespace — oid — NOT NULL
- opcowner — oid — NOT NULL
- opcfamily — oid — NOT NULL
- opcintype — oid — NOT NULL
- opcdefault — boolean — NOT NULL
- opckeytype — oid — NOT NULL
pg_operator
- oid — oid — NOT NULL
- oprname — information_schema.sql_identifier — NOT NULL
- oprnamespace — oid — NOT NULL
- oprowner — oid — NOT NULL
- oprkind — "char" — NOT NULL
- oprcanmerge — boolean — NOT NULL
- oprcanhash — boolean — NOT NULL
- oprleft — oid — NOT NULL
- oprright — oid — NOT NULL
- oprresult — oid — NOT NULL
- oprcom — oid — NOT NULL
- oprnegate — oid — NOT NULL
- oprcode — regproc — NOT NULL
- oprrest — regproc — NOT NULL
- oprjoin — regproc — NOT NULL
pg_opfamily
- oid — oid — NOT NULL
- opfmethod — oid — NOT NULL
- opfname — information_schema.sql_identifier — NOT NULL
- opfnamespace — oid — NOT NULL
- opfowner — oid — NOT NULL
pg_partitioned_table
- partrelid — oid — NOT NULL
- partstrat — "char" — NOT NULL
- partnatts — smallint — NOT NULL
- partdefid — oid — NOT NULL
- partattrs — int2vector — NOT NULL
- partclass — oidvector — NOT NULL
- partcollation — oidvector — NOT NULL
- partexprs — pg_node_tree
pg_policy
- oid — oid — NOT NULL
- polname — information_schema.sql_identifier — NOT NULL
- polrelid — oid — NOT NULL
- polcmd — "char" — NOT NULL
- polpermissive — boolean — NOT NULL
- polroles — oid — NOT NULL
- polqual — pg_node_tree
- polwithcheck — pg_node_tree
pg_proc
- oid — oid — NOT NULL
- proname — information_schema.sql_identifier — NOT NULL
- pronamespace — oid — NOT NULL
- proowner — oid — NOT NULL
- prolang — oid — NOT NULL
- procost — real — NOT NULL
- prorows — real — NOT NULL
- provariadic — oid — NOT NULL
- prosupport — regproc — NOT NULL
- prokind — "char" — NOT NULL
- prosecdef — boolean — NOT NULL
- proleakproof — boolean — NOT NULL
- proisstrict — boolean — NOT NULL
- proretset — boolean — NOT NULL
- provolatile — "char" — NOT NULL
- proparallel — "char" — NOT NULL
- pronargs — smallint — NOT NULL
- pronargdefaults — smallint — NOT NULL
- prorettype — oid — NOT NULL
- proargtypes — oidvector — NOT NULL
- proallargtypes — oid
- proargmodes — "char"
- proargnames — text
- proargdefaults — pg_node_tree
- protrftypes — oid
- prosrc — text — NOT NULL
- probin — text
- prosqlbody — pg_node_tree
- proconfig — text
- proacl — aclitem
pg_range
- rngtypid — oid — NOT NULL
- rngsubtype — oid — NOT NULL
- rngmultitypid — oid — NOT NULL
- rngcollation — oid — NOT NULL
- rngsubopc — oid — NOT NULL
- rngcanonical — regproc — NOT NULL
- rngsubdiff — regproc — NOT NULL
pg_rewrite
- oid — oid — NOT NULL
- rulename — information_schema.sql_identifier — NOT NULL
- ev_class — oid — NOT NULL
- ev_type — "char" — NOT NULL
- ev_enabled — "char" — NOT NULL
- is_instead — boolean — NOT NULL
- ev_qual — pg_node_tree — NOT NULL
- ev_action — pg_node_tree — NOT NULL
pg_sequence
- seqrelid — oid — NOT NULL
- seqtypid — oid — NOT NULL
- seqstart — bigint — NOT NULL
- seqincrement — bigint — NOT NULL
- seqmax — bigint — NOT NULL
- seqmin — bigint — NOT NULL
- seqcache — bigint — NOT NULL
- seqcycle — boolean — NOT NULL
pg_shdepend
- dbid — oid — NOT NULL
- classid — oid — NOT NULL
- objid — oid — NOT NULL
- objsubid — integer — NOT NULL
- refclassid — oid — NOT NULL
- refobjid — oid — NOT NULL
- deptype — "char" — NOT NULL
pg_shdescription
- objoid — oid — NOT NULL
- classoid — oid — NOT NULL
- description — text — NOT NULL
pg_statistic
- starelid — oid — NOT NULL
- staattnum — smallint — NOT NULL
- stainherit — boolean — NOT NULL
- stanullfrac — real — NOT NULL
- stawidth — integer — NOT NULL
- stadistinct — real — NOT NULL
- stakind1 — smallint — NOT NULL
- stakind2 — smallint — NOT NULL
- stakind3 — smallint — NOT NULL
- stakind4 — smallint — NOT NULL
- stakind5 — smallint — NOT NULL
- staop1 — oid — NOT NULL
- staop2 — oid — NOT NULL
- staop3 — oid — NOT NULL
- staop4 — oid — NOT NULL
- staop5 — oid — NOT NULL
- stacoll1 — oid — NOT NULL
- stacoll2 — oid — NOT NULL
- stacoll3 — oid — NOT NULL
- stacoll4 — oid — NOT NULL
- stacoll5 — oid — NOT NULL
- stanumbers1 — real
- stanumbers2 — real
- stanumbers3 — real
- stanumbers4 — real
- stanumbers5 — real
- stavalues1 — anyarray
- stavalues2 — anyarray
- stavalues3 — anyarray
- stavalues4 — anyarray
- stavalues5 — anyarray
pg_statistic_ext
- oid — oid — NOT NULL
- stxrelid — oid — NOT NULL
- stxname — information_schema.sql_identifier — NOT NULL
- stxnamespace — oid — NOT NULL
- stxowner — oid — NOT NULL
- stxstattarget — integer — NOT NULL
- stxkeys — int2vector — NOT NULL
- stxkind — "char" — NOT NULL
- stxexprs — pg_node_tree
pg_statistic_ext_data
- stxoid — oid — NOT NULL
- stxdinherit — boolean — NOT NULL
- stxdndistinct — pg_ndistinct
- stxddependencies — pg_dependencies
- stxdmcv — pg_mcv_list
- stxdexpr — pg_statistic
pg_tablespace
- oid — oid — NOT NULL
- spcname — information_schema.sql_identifier — NOT NULL
- spcowner — oid — NOT NULL
- spcacl — aclitem
- spcoptions — text
pg_transform
- oid — oid — NOT NULL
- trftype — oid — NOT NULL
- trflang — oid — NOT NULL
- trffromsql — regproc — NOT NULL
- trftosql — regproc — NOT NULL
pg_trigger
- oid — oid — NOT NULL
- tgrelid — oid — NOT NULL
- tgparentid — oid — NOT NULL
- tgname — information_schema.sql_identifier — NOT NULL
- tgfoid — oid — NOT NULL
- tgtype — smallint — NOT NULL
- tgenabled — "char" — NOT NULL
- tgisinternal — boolean — NOT NULL
- tgconstrrelid — oid — NOT NULL
- tgconstrindid — oid — NOT NULL
- tgconstraint — oid — NOT NULL
- tgdeferrable — boolean — NOT NULL
- tginitdeferred — boolean — NOT NULL
- tgnargs — smallint — NOT NULL
- tgattr — int2vector — NOT NULL
- tgargs — bytea — NOT NULL
- tgqual — pg_node_tree
- tgoldtable — information_schema.sql_identifier
- tgnewtable — information_schema.sql_identifier
pg_type
- oid — oid — NOT NULL
- typname — information_schema.sql_identifier — NOT NULL
- typnamespace — oid — NOT NULL
- typowner — oid — NOT NULL
- typlen — smallint — NOT NULL
- typbyval — boolean — NOT NULL
- typtype — "char" — NOT NULL
- typcategory — "char" — NOT NULL
- typispreferred — boolean — NOT NULL
- typisdefined — boolean — NOT NULL
- typdelim — "char" — NOT NULL
- typrelid — oid — NOT NULL
- typsubscript — regproc — NOT NULL
- typelem — oid — NOT NULL
- typarray — oid — NOT NULL
- typinput — regproc — NOT NULL
- typoutput — regproc — NOT NULL
- typreceive — regproc — NOT NULL
- typsend — regproc — NOT NULL
- typmodin — regproc — NOT NULL
- typmodout — regproc — NOT NULL
- typanalyze — regproc — NOT NULL
- typalign — "char" — NOT NULL
- typstorage — "char" — NOT NULL
- typnotnull — boolean — NOT NULL
- typbasetype — oid — NOT NULL
- typtypmod — integer — NOT NULL
- typndims — integer — NOT NULL
- typcollation — oid — NOT NULL
- typdefaultbin — pg_node_tree
- typdefault — text
- typacl — aclitem
pg_user_mapping
- oid — oid — NOT NULL
- umuser — oid — NOT NULL
- umserver — oid — NOT NULL
- umoptions — text