Empty to NULL conversion - Ruby - Postgres ?
| От | Venks |
|---|---|
| Тема | Empty to NULL conversion - Ruby - Postgres ? |
| Дата | |
| Msg-id | 96bd3d570802011733h4074f441l2ef02c8618f70fd2@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Empty to NULL conversion - Ruby - Postgres ?
Re: Empty to NULL conversion - Ruby - Postgres ? |
| Список | pgsql-general |
Hi, I am trying to copy some data from MySQL to Postgres using Ruby. This is NOT a MySQL to PostgreSQL conversion project. I need to read the data from a MySQL database and load it into PostgreSQL database. How do I handle "nil" in ruby and convert them into NULL so that I can insert NULL into INT columns instead of empty values? In short I am getting the following popular error: invalid input syntax for integer: "" (PGError) This is because when I read data from MySQL, all the NULL values are converted into "nil" in Ruby and inserting them into Postgres is an issue because "nil" is being transmitted as "" (empty) and not as SQL NULL. -Venks
В списке pgsql-general по дате отправления: