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
Список
Дерево обсуждения
Use true and false when bulk-exporting boolean data Viktor Rosenfeld <listuser36@googlemail.com>
Re: Use true and false when bulk-exporting boolean data Henry Drexler <alonup8tb@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 Alban Hertroys <haramrae@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 Henry Drexler <alonup8tb@gmail.com>
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
Дата: