Revision 6415
Added by Aaron Marcuse-Kubitza over 11 years ago
| lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"PostgreSQL-only features" |
| 3 |
"^SET\b[^;]*;",, |
|
| 4 |
"^(?:GRANT|REVOKE)\b[^;]*;",, |
|
| 5 |
"^(?:CREATE|ALTER) (?:AGGREGATE|PROCEDURAL LANGUAGE|SEQUENCE|(?:CONSTRAINT )?TRIGGER|TYPE|VIEW)\b[^;]*;",, |
|
| 6 |
"(?s)^CREATE FUNCTION\b.*?(\$\w*\$).*?\1;",, |
|
| 3 |
"^SET\b[^;]*;$",,
|
|
| 4 |
"^(?:GRANT|REVOKE)\b[^;]*;$",,
|
|
| 5 |
"^(?:CREATE|ALTER) (?:AGGREGATE|PROCEDURAL LANGUAGE|SEQUENCE|(?:CONSTRAINT )?TRIGGER|TYPE|VIEW)\b[^;]*;$",,
|
|
| 6 |
"(?s)^CREATE FUNCTION\b.*?(\$\w*\$).*?\1;$",,
|
|
| 7 | 7 |
"(?s)^COMMENT\b.*?';$",, |
| 8 |
"^ALTER TABLE\b[^;]*\bSET DEFAULT nextval\([^;]*\)[^;]*;",, |
|
| 9 |
"^CREATE\b[^;]*\bINDEX\b[^;]*\([^;]*\([^;]*;",, |
|
| 8 |
"^ALTER TABLE\b[^;]*\bSET DEFAULT nextval\([^;]*\)[^;]*;$",,
|
|
| 9 |
"^CREATE\b[^;]*\bINDEX\b[^;]*\([^;]*\([^;]*;$",,
|
|
| 10 | 10 |
",\n *CONSTRAINT\b.*\bCHECK\b.*?(?=,?$)",, |
| 11 | 11 |
"\bDEFAULT \w*\(.*\)",,".* rather than .*? to allow nested ()" |
| 12 | 12 |
"^(CREATE\b[^;]*\bINDEX\b[^;]*\b)USING \w+","\1", |
Also available in: Unified diff
lib/PostgreSQL-MySQL.csv: Only match a statement-terminating ; when it's at the end of a line