Postgres Pro
Downloads
Home   >   mailing lists

Thread: insert bytea data manually

insert bytea data manually

From
Muhlis Akdag
Date:
Hi,

I have a question about bytea columns. I want manually select the
column.. this looks like this..when I export it from pgadmin into a csv
file..
"10";"PK\003\004\024\000\000\000\000\000\214\22453\341\24519\036\000\000\000\03.........."

so how I can inert it back to the database manually.. like this..

insert into files (docid,file) values
(1,'PK\003\004\024\000\000\000\000\000\214\22453\341\24519\036\000\000\000\03..........")

but it brings error when i try this..?

can sombody help me how i can extract bytea data and insert it back
manually with SQL commands?

Re: insert bytea data manually

From
Kris Jurka
Date:

On Mon, 3 Oct 2005, Muhlis Akdag wrote:

> I have a question about bytea columns. I want manually select the column..
> this looks like this..when I export it from pgadmin into a csv file..
> "10";"PK\003\004\024\000\000\000\000\000\214\22453\341\24519\036\000\000\000\03.........."
>
> so how I can inert it back to the database manually.. like this..
>
> insert into files (docid,file) values
> (1,'PK\003\004\024\000\000\000\000\000\214\22453\341\24519\036\000\000\000\03..........")
>

See the documentation for the correct escapting you will need.

http://www.postgresql.org/docs/8.0/static/datatype-binary.html

You need to double the backslashes when sending the data to the backend.

Kris Jurka