Re: Bug #767: Bug when inserting in "bytea" column type - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #767: Bug when inserting in "bytea" column type
Date
Msg-id 13887.1032036550@sss.pgh.pa.us
Whole thread Raw
In response to Bug #767: Bug when inserting in "bytea" column type  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> INSERT INTO IMAGES (NAME,DATA) VALUES ('image1','\377\000\556\211\000');

You need to double all those backslashes.

            regards, tom lane

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #767: Bug when inserting in "bytea" column type
Next
From: Casey Allen Shobe
Date:
Subject: Postgres storing time in strange manner