Re: Use true and false when bulk-exporting boolean data - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Use true and false when bulk-exporting boolean data
Date
Msg-id E1C41CE1-EF51-449E-9D8C-197C24481C43@gmail.com
Whole thread Raw
In response to Re: Use true and false when bulk-exporting boolean data  (Viktor Rosenfeld <listuser36@googlemail.com>)
Responses Re: Use true and false when bulk-exporting boolean data  (Viktor Rosenfeld <listuser36@googlemail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: "Deshpande, Yogesh Sadashiv (STSD-Openview)"
Date:
Subject: Re: Postgre Performance
Next
From: Tom Lane
Date:
Subject: Re: pg_dump not including custom CAST based on table types