Redshift Research Project

System Table Tracker

System view pg_catalog.pg_attribute_info version 1.0.38698 / 2022-05-27

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