X-Original-To: pgsql-sql@postgresql.org Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 55D8D47612F for ; Tue, 11 Mar 2003 10:32:32 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Tue Mar 11 16:32:36 2003 +0100 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id QAA28214; Tue, 11 Mar 2003 16:32:34 +0100 (MET) Message-ID: <3E6E0191.B8F06EBB@rodos.fzk.de> Date: Tue, 11 Mar 2003 16:32:33 +0100 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: vernonw@gatewaytech.com Subject: Re: Special characters in SQL queries Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/262 X-Sequence-Number: 12302 > > First a single quote in text, when a backforward slash in a file path, what other special characters need padded in t wo > backslashes before using the data in a SQL statement? > > After hours' search in the PostgreSQL archive, I find a releted information on the http://www.ca.postgresql.org/users - > lounge/docs/7.2/postgres/arrays.html. It's about array data though. > > How can I find out those characters so that I can pre-process them before a SQL query? > What about size_t PQescapeString (char *to, const char *from, size_t length); from the libpq - C Library? Regards, Christoph