Hi Alban, in the end I used a COPY statement with a query and a CASE statement as suggested by Henry.
Cheers, Viktor Alban Hertroys wrote: > 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
