couldn't you just wrap it in a case statement to change the t to true etc...?
On Mon, Oct 17, 2011 at 2:29 PM, Viktor Rosenfeld <listuser36@xxxxxxxxxxxxxx> wrote:
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
