Re: Import Schema converting tinyint to Boolean?

From: Félix GERZAGUET <felix(dot)gerzaguet(at)gmail(dot)com>
To: Guyren Howe <guyren(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Import Schema converting tinyint to Boolean?
Date: 2016-01-21 09:50:30
Message-ID: CANVwZtsprEAyO2mGTEmLm1Rsm4OVGncHi_Zn0pY3aR8mfz1QRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 21, 2016 at 9:52 AM, Guyren Howe <guyren(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Waterson 2016-01-21 10:05:54 Recurring bookings
Previous Message Guyren Howe 2016-01-21 08:52:54 Import Schema converting tinyint to Boolean?