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
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 |