[TOC] ## 查看表结构 ``` > SELECT * FROM pg_attribute WHERE attrelid = 'mytable'::regclass; attrelid attname atttypid attstattarget attlen attnum attndims attcacheoff atttypmod attbyval attalign attstorage attcompression attnotnull atthasdef atthasmissing attidentity attgenerated attisdropped attislocal attinhcount attcollation attacl attoptions attfdwoptions attmissingval 17128 tableoid 26 0 4 -6 0 -1 -1 t i p t f f f t 0 0 17128 cmax 29 0 4 -5 0 -1 -1 t i p t f f f t 0 0 17128 xmax 28 0 4 -4 0 -1 -1 t i p t f f f t 0 0 17128 cmin 29 0 4 -3 0 -1 -1 t i p t f f f t 0 0 17128 xmin 28 0 4 -2 0 -1 -1 t i p t f f f t 0 0 17128 ctid 27 0 6 -1 0 -1 -1 f s p t f f f t 0 0 17128 id 23 -1 4 1 0 -1 -1 t i p t f f f t 0 0 17128 name 1043 -1 -1 2 0 -1 259 f i x f f f f t 0 100 ```