Redshift Research Project

System Table Tracker

System view pg_catalog.pg_settings version 1.0.39009 / 2022-06-08

schema	name	column	data type
pg_catalog	pg_settings	category	varchar(256)
pg_catalog	pg_settings	context	varchar(256)
pg_catalog	pg_settings	extra_desc	varchar(256)
pg_catalog	pg_settings	max_val	varchar(256)
pg_catalog	pg_settings	min_val	varchar(256)
pg_catalog	pg_settings	name	varchar(256)
pg_catalog	pg_settings	setting	varchar(256)
pg_catalog	pg_settings	short_desc	varchar(256)
pg_catalog	pg_settings	source	varchar(256)
pg_catalog	pg_settings	vartype	varchar(256)

View Text

SELECT a.name,
       a.setting,
       a.category,
       a.short_desc,
       a.extra_desc,
       a.context,
       a.vartype,
       a.source,
       a.min_val,
       a.max_val
FROM pg_show_all_settings() AS a(name varchar,
                                 setting varchar,
                                 category varchar,
                                 short_desc varchar,
                                 extra_desc varchar,
                                 context varchar,
                                 vartype varchar,
                                 source varchar,
                                 min_val varchar,
                                 max_val varchar)

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