Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_partitions version 1.0.51304 / 2023-06-04

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