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