Re: Use true and false when bulk-exporting boolean data

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Use true and false when bulk-exporting boolean data
Дата
Msg-id E1C41CE1-EF51-449E-9D8C-197C24481C43@gmail.com
обсуждение исходный текст
Ответ на Re: Use true and false when bulk-exporting boolean data  (Viktor Rosenfeld <listuser36@googlemail.com>)
Ответы Re: Use true and false when bulk-exporting boolean data
Список 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 по дате отправления:

Предыдущее
От: "Deshpande, Yogesh Sadashiv (STSD-Openview)"
Дата:
Сообщение: Re: Postgre Performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump not including custom CAST based on table types