Amazon Redshift
Database Developer Guide (API Version 2012-12-01)


Use SVV_COLUMNS to view catalog information about the columns of local and external tables and views.

SVV_COLUMNS is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access.

The SVV_COLUMNS view shows table metadata from the System Catalog Tables (tables with a PG prefix) and the SVV_EXTERNAL_COLUMNS system view. The system catalog tables describe Amazon Redshift database tables. SVV_EXTERNAL_COLUMNS describes external tables that are used with Amazon Redshift Spectrum.

Regular user can only view rows from underlying tables to which they have access. All users can see all rows from the system catalog tables. Regular users can see rows from SVV_EXTERNAL_COLUMNS only if they have been granted access to the metatdata.

Table Columns

Column Name Data Type Description
table_catalog text The name of the catalog where the table is.
table_schema text The schema name for the table.
table_name text The name of the table.
column_name text The name of the column.
ordinal_position int The position of the column in the table.
column_default text The default value of the column.
is_nullable text A value that indicates whether the column is nullable.
data_type text The data type of the column.
character_maximum_length int The maximum number of characters in the column.
numeric_precision int The numeric precision.
numeric_precision_radix int The numeric precision radix.
numeric_scale int The numeric scale.
datetime_precision int The datetime precision.
interval_type text The interval type.
interval_precision text The interval precision.
character_set_catalog text The character set catalog.
character_set_schema text The character set schema.
character_set_name text The character set name.
collation_catalog text The collation catalog.
collation_schema text The collation schema.
collation_name text The collation name.
domain_name text The domain name.
remarks text Remarks

On this page: