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

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.

Thanks,
Viktor

Henry Drexler wrote:

> 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
> >