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','';