Setting gpre Client Dialect

Go Up to Preprocessing

By default, gpre takes on the dialect of the database to which it is connected. This enables gpre to parse older source files without modification. You can set gpre to operate as a client in a different dialect in these ways:

Start gpre with option -sql_dialect n, where n is 1, 2, or 3:

gpre -sql_dialect n

Specify dialect within the source, for example:

EXEC SQL
SET SQL DIALECT n

gpre dialect precedence is as follows:

• lowest - dialect of an attached database
• middle - dialect specified on the command line
• highest - dialect specified in the source

Advance To:

• Using a File Extension to Specify Language