2009 20:07, George Kao wrote:
> The data in escaped octal is not acceptable. Is there a way to dump
> the bytea from posgresql database in hex format? I think it is
> acceptable by
No, I'm fairly sure that you can't do it directly in the pg_dump output.
However, you could
-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Thursday, May 14, 2009 2:14 PM
To: George Kao
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] how to extract data from bytea so it is be used in
blob for mysql database
On 14/05/2009 14:18, George Kao wrote:
I have tried to pg_dump only one single table with bytea field and the
result is the same when I come to restore with mysql.
-Original Message-
From: Allan Kamau [mailto:all...@sanbi.ac.za]
Sent: Thursday, May 14, 2009 11:15 AM
To: Postgres-General
Cc: George Kao
Subject: Re: [GENERAL
run the script with mysql.exe to store the database except
for the bytea data...
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Raymond
O'Donnell
Sent: Wednesday, May 13, 2009 5:52 PM
To: George Kao
Cc: pgsql-ge
I used pg_dump to extract the data from my database with bytea fields
(having pictures) in plain text format. I encoutered some problems to
restore those bytea data to the blobs field in a Mysql database. Any advice?
