Revision 10441
Added by Aaron Marcuse-Kubitza over 11 years ago
| bin/my2pg | ||
|---|---|---|
| 13 | 13 |
-e 's/^ ((CONSTRAINT "[^"]*" )?((FULLTEXT|FOREIGN) )?KEY .*[^,])(,?)$/ \/*\1*\/CHECK (true)\5/' \ |
| 14 | 14 |
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \ |
| 15 | 15 |
-e 's/ (CHARACTER SET|COLLATE) [0-9A-Za-z_]+//g' \ |
| 16 |
-e "s/ COMMENT '[^']*'//g" \ |
|
| 16 |
-e "s/ COMMENT '.*'//g |
|
| 17 |
# COMMENTs never span multiple lines because newlines are encoded as \n" \ |
|
| 17 | 18 |
${sql_ascii:+-e 's/ varbinary/ text/g' }\
|
| 18 | 19 |
-e 's/ (binary|blob|varbinary)/ bytea/g' \ |
| 19 | 20 |
-e 's/ (tinytext|mediumtext|longtext)/ text/g' \ |
Also available in: Unified diff
bin/my2pg: COMMENT: also match COMMENTs with embedded ', because there will only be one COMMENT per line, so the contents of the COMMENT can just extend to the last ' on the line