On Aug 11, 2010, at 13:00 , Scott Frankel wrote: > The pg docs say that booleans can be stored as 't', 'true', 'y', 'yes', or > '1'.
Booleans are not "stored" as those literals: those are only acceptable literals (i.e., string representations) for boolean values. > I'm using pg_dump to create an SQL script for importing into another > database. This will happen automatically and repeatedly. Unfortunately, the > other database (sqlite) is limited to only integer representation of > booleans: 0 or 1. One option is to use COPY to export the data in a format you like. For example: COPY (SELECT CAST(boolean_column AS INT) FROM my_table) TO STDOUT. Then write a script which reads the exported data files and loads them into your sqlite database. COPY WITH CSV would likely be helpful as well. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
