Postgres Pro
Downloads
Home   >   mailing lists

Re: Import Schema converting tinyint to Boolean? - Mailing list pgsql-general

From Félix GERZAGUET
Subject Re: Import Schema converting tinyint to Boolean?
Date
Msg-id CANVwZtsprEAyO2mGTEmLm1Rsm4OVGncHi_Zn0pY3aR8mfz1QRg@mail.gmail.com
Whole thread Raw
In response to Import Schema converting tinyint to Boolean?  (Guyren Howe <guyren@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Guyren Howe
Date:
Subject: Import Schema converting tinyint to Boolean?
Next
From: Kevin Waterson
Date:
Subject: Recurring bookings