Обсуждение: Postgres-dump with binary data!

Hi,

maybe someone of you may help me:
It is possible to insert binary data in text fields:  insert (text) into
table values (\1\2\3\255\0\3\7);
But is it possible to dump this data into a file with pg_dump???

I think with the C-API I can extract the data, but I cannnot backup this
table with
pg_dump. Is there any possibility to do that?
I had this problem while converting my data from mysql (sorry!)  blob
fields
to postgres text fields.  This way is okay, but the other direction
doesn't work.
I want to store my data in a postgres database. But one of the
advantages of
SQL is to simply dump a table and reload it into another database.
But this seems not to work with binary data. Is that right?

Thank you, Tim