Redshift Observatory

System Table Tracker

System view pg_catalog.stl_load_options version 1.0.51781 / 2023-06-13

schema name column data type
pg_catalog stl_load_options authentication int4
pg_catalog stl_load_options compression_type int4
pg_catalog stl_load_options comprows int4
pg_catalog stl_load_options compupdate int4
pg_catalog stl_load_options cross_region char(15)
pg_catalog stl_load_options encoding int4
pg_catalog stl_load_options err_count int4
pg_catalog stl_load_options format int4
pg_catalog stl_load_options ignore_header int4
pg_catalog stl_load_options max_error int4
pg_catalog stl_load_options opt_acceptanydate int4
pg_catalog stl_load_options opt_acceptinvchars int4
pg_catalog stl_load_options opt_blankasnull int4
pg_catalog stl_load_options opt_column_list int4
pg_catalog stl_load_options opt_csv int4
pg_catalog stl_load_options opt_dateformat int4
pg_catalog stl_load_options opt_delimiter int4
pg_catalog stl_load_options opt_emptyasnull int4
pg_catalog stl_load_options opt_encrypted int4
pg_catalog stl_load_options opt_escape int4
pg_catalog stl_load_options opt_explicit_ids int4
pg_catalog stl_load_options opt_fillrecord int4
pg_catalog stl_load_options opt_fixedwidth int4
pg_catalog stl_load_options opt_ignoreallerrors int4
pg_catalog stl_load_options opt_ignoreblanklines int4
pg_catalog stl_load_options opt_jsonpath int4
pg_catalog stl_load_options opt_manifest int4
pg_catalog stl_load_options opt_noload int4
pg_catalog stl_load_options opt_null_as int4
pg_catalog stl_load_options opt_removequotes int4
pg_catalog stl_load_options opt_roundec int4
pg_catalog stl_load_options opt_simplify int4
pg_catalog stl_load_options opt_simplify_threshold float8
pg_catalog stl_load_options opt_ssh int4
pg_catalog stl_load_options opt_statupdate int4
pg_catalog stl_load_options opt_temp_table int4
pg_catalog stl_load_options opt_timeformat int4
pg_catalog stl_load_options opt_trimblanks int4
pg_catalog stl_load_options opt_truncatecolumns int4
pg_catalog stl_load_options query int8
pg_catalog stl_load_options read_ratio int4
pg_catalog stl_load_options row_count int8
pg_catalog stl_load_options source int4

View Text

SELECT stll_load_options.query,
       stll_load_options.row_count,
       stll_load_options.source,
       stll_load_options.format,
       stll_load_options.authentication,
       stll_load_options.compression_type,
       stll_load_options.encoding,
       stll_load_options.compupdate,
       stll_load_options.comprows,
       stll_load_options.max_error,
       stll_load_options.err_count,
       stll_load_options.read_ratio,
       stll_load_options.ignore_header,
       stll_load_options.cross_region,
       stll_load_options.opt_delimiter,
       stll_load_options.opt_statupdate,
       stll_load_options.opt_fixedwidth,
       stll_load_options.opt_column_list,
       stll_load_options.opt_temp_table,
       stll_load_options.opt_manifest,
       stll_load_options.opt_jsonpath,
       stll_load_options.opt_csv,
       stll_load_options.opt_ssh,
       stll_load_options.opt_encrypted,
       stll_load_options.opt_acceptanydate,
       stll_load_options.opt_acceptinvchars,
       stll_load_options.opt_blankasnull,
       stll_load_options.opt_dateformat,
       stll_load_options.opt_emptyasnull,
       stll_load_options.opt_escape,
       stll_load_options.opt_explicit_ids,
       stll_load_options.opt_fillrecord,
       stll_load_options.opt_ignoreblanklines,
       stll_load_options.opt_null_as,
       stll_load_options.opt_removequotes,
       stll_load_options.opt_roundec,
       stll_load_options.opt_timeformat,
       stll_load_options.opt_trimblanks,
       stll_load_options.opt_truncatecolumns,
       stll_load_options.opt_noload,
       stll_load_options.opt_simplify,
       stll_load_options.opt_simplify_threshold,
       stll_load_options.opt_ignoreallerrors
FROM stll_load_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