PostgreSQL interactive terminal

PSQL commands

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Applies to

• PostgreSQL

• Netezza

Description

PSQL is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input can be from a file. In addition, it provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks. (PSQL documentation).

In Snowflake, PSQL commands are not applicable. While no longer needed for execution, SnowConvert retains the original PSQL command as a comment

Sample Source Patterns

Input Code:

Greenplum

IN -> PostgreSQL_01.sql

\set ON_ERROR_STOP TRUE

Output Code:

Snowflake

OUT -> PostgreSQL_01.sql

----** SSC-FDM-PG0015 - PSQL COMMAND IS NOT APPLICABLE IN SNOWFLAKE. **
--\set ON_ERROR_STOP TRUE

Related EWIs

1. SSC-FDM-PG0015 : PSQL command is not applicable in Snowflake.