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