Postgres-dump with binary data!

From: Tim Röstermundt <rosterm(at)uni-muenster(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres-dump with binary data!
Date: 1999-03-11 13:33:28
Message-ID: 36E7C628.59C3FFF4@uni-muenster.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Browse pgsql-general by date

  From Date Subject
Next Message William J. Stotts 1999-03-11 14:39:52 Re: [GENERAL] question on converting M$ Access tables
Previous Message Stefan Wehner 1999-03-11 13:22:12 Bug with sequences in 6.4.2