Revision 687
Added by Aaron Marcuse-Kubitza almost 13 years ago
| lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 |
,,"PostgreSQL-only features" |
|
| 3 |
"^SET\b[^;]*;",, |
|
| 4 |
"^(?:CREATE|ALTER) (?:AGGREGATE|SEQUENCE)\b[^;]*;",, |
|
| 5 |
"^COMMENT\b[^;]*;",, |
|
| 6 |
"^ALTER TABLE\b[^;]*\bSET DEFAULT nextval\([^;]*\)[^;]*;",, |
|
| 7 |
"^CREATE\b[^;]*\bINDEX\b[^;]*\([^;]*\([^;]*;",, |
|
| 8 |
"\bDEFAULT \w*\(.*\)",,".* rather than .*? to allow nested ()" |
|
| 9 |
"^(CREATE\b[^;]*\bINDEX\b[^;]*\b)USING \w+","\1", |
|
| 10 |
"(?<=\bALTER TABLE )ONLY ",, |
|
| 11 |
,,"syntax changes" |
|
| 2 | 12 |
"^--(?=\S)","\g<0> ", |
| 3 | 13 |
"""([^""]*?)""","`\1`", |
| 4 | 14 |
"(?<=DEFAULT )(\d+|'[^']*')::\w+(?: \w+)*","\1", |
| 5 | 15 |
"(\d+|'[^']*')::(\w+(?: \w+)*)","CAST(\1 AS \2)", |
| 16 |
,,"datatypes" |
|
| 6 | 17 |
"\bserial( NOT NULL\b)?","int(11)\1 AUTO_INCREMENT", |
| 18 |
"oid","int(11)", |
|
| 7 | 19 |
"Integer","int(11)", |
| 8 | 20 |
"Boolean","int(1)", |
| 9 |
" with time zone\b","", |
|
| 10 |
"fulltext","\g<0>__" |
|
| 11 |
"\btimestamp\b(?: with time zone\b)?(?! NOT NULL\b)","\g<0> NULL" |
|
| 21 |
"bytea","blob", |
|
| 22 |
" with time zone\b",, |
|
| 23 |
"fulltext","\g<0>__", |
|
| 24 |
"\btimestamp\b(?: with time zone\b)?(?! NOT NULL\b)","\g<0> NULL", |
|
Also available in: Unified diff
PostgreSQL-MySQL.csv: Added translations for syntaxes used by pg_dump