Hi all,
Is it possible to control the representation of boolean data in a
pg_dump?
The pg docs say that booleans can be stored as 't', 'true', 'y',
'yes', or '1'. My db is storing them as 't' and pg_dump is outputing
them as 'true'. Can I coerce pg_dump to output 't' as 1?
I'm using pg_dump to create an SQL script for importing into another
database. This will happen automatically and repeatedly.
Unfortunately, the other database (sqlite) is limited to only integer
representation of booleans: 0 or 1.
I'm currently using the following command:
pg_dump -aDFp -v mydatabase > mydatabase_BAK.sql
Thanks!
Scott