Backslashes in bytea values
От | Lewis Kapell |
---|---|
Тема | Backslashes in bytea values |
Дата | |
Msg-id | 4B2BD8EF.40002@setonhome.org обсуждение исходный текст |
Ответы |
Re: Backslashes in bytea values
|
Список | pgsql-admin |
My company is using Postgres 8.3.8. We have some tables with bytea columns that store file data such as the contents of PDF or RTF files. The escape_string_warning parameter is on, and inserting this kind of data causes the backslash warning to be generated, since the backslash character appears in the raw data of these types of files. I have updated much of our code to use the E'' syntax in order to suppress these messages. I am trying to figure out what the repercussions would be if I were to turn on the standard_conforming_strings parameter. None of our code actually uses a backslash to escape a double-quote, but I don't know how this would affect the bytea values which I discussed above. How are backslashes affected if they are actually part of the raw data? -- Thank you, Lewis Kapell Computer Operations Seton Home Study School
В списке pgsql-admin по дате отправления: