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.
>