| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Muhlis Akdag <mican58(at)gmail(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: insert bytea data manually |
| Date: | 2005-10-03 23:01:13 |
| Message-ID: | Pine.BSO.4.61.0510031759030.30667@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kumar | 2005-10-04 14:00:18 | give_solution |
| Previous Message | Muhlis Akdag | 2005-10-03 21:10:18 | insert bytea data manually |