pg_dump and boolean format - Mailing list pgsql-general

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