Postgres Pro
Downloads
Home   >   mailing lists

insert bytea data manually - Mailing list pgsql-jdbc

From Muhlis Akdag
Subject insert bytea data manually
Date
Msg-id 43419E3A.5090307@gmail.com
Whole thread Raw
Responses Re: insert bytea data manually
List pgsql-jdbc
Tree view 
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?

pgsql-jdbc by date:

Previous
From: Russell Francis
Date:
Subject: Re: queries against CIDR fail against 8.0.3?
Next
From: Kris Jurka
Date:
Subject: Re: insert bytea data manually