On 18 Oct 2011, at 17:54, Viktor Rosenfeld wrote: > I was looking for an easier, more automatic way, but I wrote a few > scripts that wrapped the boolean fields in case statements as suggested. You are aware that COPY accepts a query as well? You could also have created a VIEW over that table that translates those values. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general