Redshift Research Project

System Table Tracker

System Table Version 1.0.41533 / 2022-09-18

schema name column data type
pg_catalog svv_external_partitions compressed int4
pg_catalog svv_external_partitions input_format text
pg_catalog svv_external_partitions location text
pg_catalog svv_external_partitions output_format text
pg_catalog svv_external_partitions parameters text
pg_catalog svv_external_partitions schemaname text
pg_catalog svv_external_partitions serde_parameters text
pg_catalog svv_external_partitions serialization_lib text
pg_catalog svv_external_partitions tablename text
pg_catalog svv_external_partitions values text

View Text

SELECT btrim(CAST(stv_external_partitions.schemaname AS text)) AS schemaname,
       btrim(CAST(stv_external_partitions.tablename AS text)) AS tablename,
       btrim(CAST(stv_external_partitions.values AS text)) AS values,
       btrim(CAST(stv_external_partitions.location AS text)) AS location,
       btrim(CAST(stv_external_partitions.input_format AS text)) AS input_format,
       btrim(CAST(stv_external_partitions.output_format AS text)) AS output_format,
       btrim(CAST(stv_external_partitions.serialization_lib AS text)) AS serialization_lib,
       btrim(CAST(stv_external_partitions.serde_parameters AS text)) AS serde_parameters,
       stv_external_partitions.compressed,
       btrim(CAST(stv_external_partitions.parameters AS text)) AS parameters
FROM stv_external_partitions
ORDER BY btrim(CAST(stv_external_partitions.schemaname AS text)),
         btrim(CAST(stv_external_partitions.tablename AS text)),
         btrim(CAST(stv_external_partitions.values AS text))


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