Revision 6070
Added by Aaron Marcuse-Kubitza about 12 years ago
| my2pg | ||
|---|---|---|
| 14 | 14 |
-e 's/^ KEY "([^"]*)" \([^)]*\)/ "\1_index" boolean/' \ |
| 15 | 15 |
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \ |
| 16 | 16 |
-e 's/ CHARACTER SET [0-9A-Za-z_]+//g' \ |
| 17 |
-e "s/ COMMENT '[^']*'//g" \ |
|
| 17 | 18 |
-e 's/ longtext/ text/g' \ |
| 18 | 19 |
-e 's/ (int|smallint|tinyint)([ (])/ integer\2/g' \ |
| 19 | 20 |
-e 's/ double/ double precision/g' \ |
Also available in: Unified diff
my2pg: Also remove column comments. Note that these cannot be translated by sed, because PostgreSQL only allows setting column comments in a separate statement, not inline with the column's entry in the CREATE TABLE statement, and sed can only make replacements contiguous with the input line.