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