Re: Import Schema converting tinyint to Boolean?

Поиск
Список
Период
Сортировка
От Félix GERZAGUET
Тема Re: Import Schema converting tinyint to Boolean?
Дата
Msg-id CANVwZtsprEAyO2mGTEmLm1Rsm4OVGncHi_Zn0pY3aR8mfz1QRg@mail.gmail.com
обсуждение исходный текст
Ответ на Import Schema converting tinyint to Boolean?  (Guyren Howe <guyren@gmail.com>)
Список pgsql-general
On Thu, Jan 21, 2016 at 9:52 AM, Guyren Howe <guyren@gmail.com> wrote:
I'm converting a MySQL database to a Postgres database by doing a bunch of CREATE TABLE… AS SELECT * FROM, but the tinyints are coming across as tinyints.

Seems like there ought to be an option somewhere to have them behave like Booleans but I can't see it.

For that part of your question, maybe you could adapt the method described here: http://adpgtech.blogspot.fr/2016/01/using-postgresql-95s-import-foreign.html

Félix

В списке pgsql-general по дате отправления:

Предыдущее
От: Guyren Howe
Дата:
Сообщение: Import Schema converting tinyint to Boolean?
Следующее
От: Kevin Waterson
Дата:
Сообщение: Recurring bookings