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