Redshift - System catalog tables¶
Note
This is a work in progress.
Description ¶
The system catalogs store schema metadata, such as information about tables and columns. System catalog tables have a PG prefix.
The standard PostgreSQL catalog tables are accessible to Amazon Redshift users. (Redshift SQL Language reference System catalog tables).
The following table outlines how references to SQL functions defined in the pg_catalog in Redshift are transformed.
Mapping of SQL functions from the pg_catalog¶
| Redshift | Snowflake |
|---|---|
| pg_catalog.row_number() | row_number() |
| pg_catalog.replace() | replace() |
| pg_catalog.lead() | lead() |