SnowConvert AI - PostgreSQL - PostgreSQL interactive terminal¶

PSQL commands

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 AI retains the original PSQL command as a comment

Sample Source Patterns¶

Input Code:¶

Greenplum¶

\set ON_ERROR_STOP TRUE
Copy

Output Code:¶

Snowflake¶

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