Use true and false when bulk-exporting boolean data

Поиск
Список
Период
Сортировка
От Viktor Rosenfeld
Тема Use true and false when bulk-exporting boolean data
Дата
Msg-id 20111017182924.GB9299@client199-86.wlan.hu-berlin.de
обсуждение исходный текст
Ответы Re: Use true and false when bulk-exporting boolean data
Список pgsql-general
Hi,

I need to move data from PostgreSQL to MonetDB and also bulk-import data
into MonetDB that was bulk-exported from PostgreSQL by other people. My
problem is that boolean data is exported by PostgreSQL using the values
"t" and "f" (unquoted) and that MonetDB expects "true" and "false".  Is
there a way to change how boolean columns are exported?

I'm using the following command to export:

  \copy table to 'filename' WITH NULL 'NULL';

And to import (in MonetDB):

  copy into table from '/path/to/filename' USING DELIMITERS '\t','\n','';

Cheers,
Viktor

В списке pgsql-general по дате отправления:

Предыдущее
От: David McKeone
Дата:
Сообщение: Re: Mac OS X 10.6 - libpq.dylib vs. libpq.a and PQisthreadsafe()
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: 9.1 got really fast ;)