This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Medium
Description
The exclude constraint used in PostgreSQL is not supported by Snowflake.
Code Example
Input Code:
CREATE TABLE Table1 (
id int,
EXCLUDE USING gist (id WITH &&)
);
Output Code:
CREATE TABLE Table1 (
id int,
-- ** MSC-ERROR - MSC-PG0009 - EXCLUDE CONSTRAINT IS NOT SUPPORTED IN SNOWFLAKE. **
-- EXCLUDE USING gist (id WITH &&)
);