tring to
hex?
-Original Message-
From: Raymond O'Donnell [mailto:r...@iol.ie]
Sent: Thursday, May 14, 2009 3:15 PM
To: george@group-upc.com
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/
On 14/05/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 maybe use the func
-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:
On 14/05/2009 14:18, George Kao wrote:
> The platform is WinXP. I have database with fields of bytea in Posgresql
> 8.1. The objective was to transfer the entire databasae (schema + data)
> to Mysql 5.1. I used the pg_dump from Posgresql 8.1 to extract the
> schema and data. With some minor touch-u
> 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
13/05/2009 21:56, George Kao wrote:
>> I used pg_dump to extract the data from my database with bytea fields
>> (having
> -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-general@postgresql.org
> Subject: Re: [GENERAL] how to e
neral@postgresql.org
Subject: Re: [GENERAL] how to extract data from bytea so it is be used
in blob for mysql database
On 13/05/2009 21:56, George Kao wrote:
> I used pg_dump to extract the data from my database with bytea fields
> (having pictures) in plain text format. I encoutered some
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?
On 13/05/2009 21:56, George Kao wrote:
> 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?
A bit more detail would be nice
