Redshift Observatory

System Table Tracker

System view pg_catalog.svv_external_partitions version 1.0.76142 / 2024-10-08

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers