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@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 > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
