Category: Redshift

In Redshift, you can move data from a source table to a target table by using ‘ALTER TABLE APPEND’. Syntax:

You can query the PG_TABLE_DEF system catalog view to view the definition of a table in Redshift database. SELECT *

You can query the system catalog view pg_proc_info to list all the stored procedures in a Redshift database. pg_proc_info view

In Redshift database, COALESCE is the alias for NVL function. Both NVL and COALESCE return the same output. NVL returns

Concatenation of values can be done either by using the concatenation operator || or the CONCAT function. Resulting output is

Run the below select statement to view the ‘current schema’. ‘Current schema’ is the default schema for database object creation

You can query the pg_proc_info system catalog view to list all the user defined functions in a redshift database. pg_proc_info

You can query the pg_proc system catalog table to view the definition of a user defined function(UDF) in Redshift database

Use SUBSTRING function to get the first character of a string in Redshift database. Syntax: select substring(‘string’,starting position,number of characters);