SQL migration from MySQL to PostgreSQL

From annawiki
Revision as of 2022-10-29T14:44:54 by Tobiasco (talk | contribs)
  1. change LIKE to ILIKE : LIKE is not case-sensitive in MySQL, but in PostgreSQL it is !! query will then return an error in MySQL
  2. see also Postgresql vs Mysql
  3. automatic conversation (which tool?) : suspected: turned the type of some fields (select list?) into boolean, i.e. the type "select list" needs to be changed before or treated in another way, in tango.info affected: gender field which had allowed values of 1,2,9 - as in ISO 5218 - and NULL
Retrieved from "http://anna.info/x/wiki/w/index.php?title=SQL_migration_from_MySQL_to_PostgreSQL&oldid=7569"