Skip to content

Instantly share code, notes, and snippets.

@keithf4
Created November 30, 2015 21:25
Show Gist options
  • Save keithf4/2026971df875584d5c0e to your computer and use it in GitHub Desktop.
Save keithf4/2026971df875584d5c0e to your computer and use it in GitHub Desktop.
Catalog info
# select * from pg_class where oid = 17197646;
-[ RECORD 1 ]--+-------------------------------------------------------------------------------------------------------------------
relname | sku_average_costs_in_our_possession
relnamespace | 12157021
reltype | 17197648
reloftype | 0
relowner | 6779214
relam | 0
relfilenode | 17197646
reltablespace | 0
relpages | 0
reltuples | 0
relallvisible | 0
reltoastrelid | 0
relhasindex | f
relisshared | f
relpersistence | p
relkind | v
relnatts | 51
relchecks | 0
relhasoids | f
relhaspkey | f
relhasrules | t
relhastriggers | f
relhassubclass | f
relispopulated | t
relreplident | n
relfrozenxid | 0
relminmxid | 0
relacl | {***sanitized***}
reloptions | «NULL»
# select * from pg_type where oid = 17197648;
-[ RECORD 1 ]--+------------------------------------
typname | sku_average_costs_in_our_possession
typnamespace | 12157021
typowner | 6779214
typlen | -1
typbyval | f
typtype | c
typcategory | C
typispreferred | f
typisdefined | t
typdelim | ,
typrelid | 17197646
typelem | 0
typarray | 17197647
typinput | record_in
typoutput | record_out
typreceive | record_recv
typsend | record_send
typmodin | -
typmodout | -
typanalyze | -
typalign | d
typstorage | x
typnotnull | f
typbasetype | 0
typtypmod | -1
typndims | 0
typcollation | 0
typdefaultbin | «NULL»
typdefault | «NULL»
typacl | «NULL»
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment