insert bytea data manually

From: Muhlis Akdag <mican58(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: insert bytea data manually
Date: 2005-10-03 21:10:18
Message-ID: 43419E3A.5090307@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-10-03 23:01:13 Re: insert bytea data manually
Previous Message Russell Francis 2005-10-03 21:02:51 Re: queries against CIDR fail against 8.0.3?