Redshift Observatory

System Table Tracker

System view pg_catalog.pg_attribute_info version 1.0.52931 / 2023-07-07

schema name column data type
pg_catalog pg_attribute_info attacl aclitem[]
pg_catalog pg_attribute_info attalign char(1)
pg_catalog pg_attribute_info attbyval bool
pg_catalog pg_attribute_info attcacheoff int4
pg_catalog pg_attribute_info attencodingtype int2
pg_catalog pg_attribute_info attencrypttype int2
pg_catalog pg_attribute_info atthasdef bool
pg_catalog pg_attribute_info attinhcount int4
pg_catalog pg_attribute_info attisdistkey bool
pg_catalog pg_attribute_info attisdropped bool
pg_catalog pg_attribute_info attislocal bool
pg_catalog pg_attribute_info attispreloaded bool
pg_catalog pg_attribute_info attlen int2
pg_catalog pg_attribute_info attname name
pg_catalog pg_attribute_info attndims int4
pg_catalog pg_attribute_info attnotnull bool
pg_catalog pg_attribute_info attnum int2
pg_catalog pg_attribute_info attrelid oid
pg_catalog pg_attribute_info attsortkeyord int4
pg_catalog pg_attribute_info attstattarget int4
pg_catalog pg_attribute_info attstorage char(1)
pg_catalog pg_attribute_info atttypid oid
pg_catalog pg_attribute_info atttypmod int4

View Text

SELECT pa.attrelid,
       pa.attname,
       pa.atttypid,
       pa.attstattarget,
       pa.attlen,
       pa.attnum,
       pa.attndims,
       pa.attcacheoff,
       pa.atttypmod,
       pa.attbyval,
       pa.attstorage,
       pa.attalign,
       pa.attnotnull,
       pa.atthasdef,
       pa.attisdropped,
       pa.attislocal,
       pa.attinhcount,
       pa.attisdistkey,
       pa.attispreloaded,
       pa.attsortkeyord,
       pa.attencodingtype,
       pa.attencrypttype,
       pac.attacl
FROM pg_attribute AS pa
     LEFT JOIN pg_attribute_acl AS pac ON pa.attrelid = pac.attrelid
                                      AND pa.attnum = pac.attnum


Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers