Redshift Observatory

System Table Tracker

System view pg_catalog.stl_unload_options version 1.0.40677 / 2022-08-14

schema	name	column	data type
pg_catalog	stl_unload_options	authentication	int4
pg_catalog	stl_unload_options	compression_type	int4
pg_catalog	stl_unload_options	cross_region	char(15)
pg_catalog	stl_unload_options	encryption_type	int4
pg_catalog	stl_unload_options	format	int4
pg_catalog	stl_unload_options	is_encrypted_auto	int4
pg_catalog	stl_unload_options	is_header	int4
pg_catalog	stl_unload_options	is_write_ext_tbl	int4
pg_catalog	stl_unload_options	manifest	int4
pg_catalog	stl_unload_options	maxfilesize	int8
pg_catalog	stl_unload_options	num_part_col	int4
pg_catalog	stl_unload_options	opt_addquotes	int4
pg_catalog	stl_unload_options	opt_allowoverwrite	int4
pg_catalog	stl_unload_options	opt_cleanpath	int4
pg_catalog	stl_unload_options	opt_delimiter	int4
pg_catalog	stl_unload_options	opt_escape	int4
pg_catalog	stl_unload_options	opt_fixedwidth	int4
pg_catalog	stl_unload_options	opt_incld_part_col	int4
pg_catalog	stl_unload_options	opt_null_as	int4
pg_catalog	stl_unload_options	opt_parallel	int4
pg_catalog	stl_unload_options	query	int8
pg_catalog	stl_unload_options	row_count	int8
pg_catalog	stl_unload_options	rowgroupsize	int8

View Text

SELECT stll_unload_options.query,
       stll_unload_options.row_count,
       stll_unload_options.format,
       stll_unload_options.authentication,
       stll_unload_options.compression_type,
       stll_unload_options.encryption_type,
       stll_unload_options.manifest,
       stll_unload_options.maxfilesize,
       stll_unload_options.cross_region,
       stll_unload_options.opt_delimiter,
       stll_unload_options.opt_fixedwidth,
       stll_unload_options.opt_addquotes,
       stll_unload_options.opt_null_as,
       stll_unload_options.opt_escape,
       stll_unload_options.opt_allowoverwrite,
       stll_unload_options.opt_parallel,
       stll_unload_options.is_header,
       stll_unload_options.num_part_col,
       stll_unload_options.opt_incld_part_col,
       stll_unload_options.is_write_ext_tbl,
       stll_unload_options.is_encrypted_auto,
       stll_unload_options.opt_cleanpath,
       stll_unload_options.rowgroupsize
FROM stll_unload_options

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