Project

General

Profile

« Previous | Next » 

Revision 8943

bin/my2pg: support $sql_ascii mode, where varbinary is translated to text instead of bytea

View differences:

bin/my2pg
17 17
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \
18 18
-e 's/ (CHARACTER SET|COLLATE) [0-9A-Za-z_]+//g' \
19 19
-e "s/ COMMENT '[^']*'//g" \
20
${sql_ascii:+-e 's/ varbinary/ text/g' }\
20 21
-e 's/ (binary|blob|varbinary)/ bytea/g' \
21 22
-e 's/ (tinytext|mediumtext|longtext)/ text/g' \
22 23
-e 's/ (int|mediumint|smallint|tinyint)([ (])/ integer\2/g' \

Also available in: Unified diff