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

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(at)googlemail(dot)com
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>