Re: Import Schema converting tinyint to Boolean?

[Félix GERZAGUET <felix.gerzaguet@xxxxxxxxx>]

On Thu, Jan 21, 2016 at 9:52 AM, Guyren Howe <guyren@xxxxxxxxx> 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