Re: escaping and quoting - Mailing list pgsql-general

From Maarten Deprez
Subject Re: escaping and quoting
Date
Msg-id 1211369582.9759.8.camel@simbelmyne.be.eu.org
Whole thread Raw
In response to Re: escaping and quoting  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Responses Re: escaping and quoting
List pgsql-general
Albe Laurenz wrote:
> Does the program work correctly despite the warnings?

At least it seems so. I'm using it as email server without problems.


> What API are you using (there is no EscapeBytea function in the C API)?

It's the PQescapeBytea function from libpq. Note that i didn't write the
program, so i don't know the code so well.


> Exactly how does the bytea string constant look that you send to the server?

For example (taken from the log and completed a bit):
INSERT INTO ... (..., messageblk,blocksize, physmessage_id) VALUES
(0,'SA\\304...')


> Are there any other strings with backslashes in your statements?

Don't know, probably yes. The backslashes are probably generated by the
escape function.


Greetings,
Maarten Deprez



pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: XML2 module and xpath_table
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"