X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D59819DC8DB for ; Tue, 17 Jan 2006 03:20:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54190-05 for ; Tue, 17 Jan 2006 03:20:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [151.155.5.143]) by postgresql.org (Postfix) with ESMTP id B696C9DC870 for ; Tue, 17 Jan 2006 03:20:29 -0400 (AST) Received: from [172.16.1.181] grzm [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.6 $ on Linux; Tue, 17 Jan 2006 00:20:28 -0700 In-Reply-To: <00fc01c61bb4$5ae92590$1e21100a@ghwk02002147> References: <00fc01c61bb4$5ae92590$1e21100a@ghwk02002147> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <963723D6-0891-4EF0-8324-0D4E5FCF69AA@myrealbox.com> Cc: Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Characters that needs escape characters when inserting to database Date: Tue, 17 Jan 2006 16:20:23 +0900 To: "Christian Paul B. Cosinas" X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.4 required=5 tests=[AWL=0.400] X-Spam-Score: 0.4 X-Spam-Level: X-Archive-Number: 200601/105 X-Sequence-Number: 23894 On Jan 18, 2006, at 7:21 , Christian Paul B. Cosinas wrote: > Can anyone give me a list of characters that needs to be preceded > by an > escape character before inserting to database. Take a look at this documentation on string constants. It should answer the questions you have. http://www.postgresql.org/docs/current/interactive/sql- syntax.html#SQL-SYNTAX-STRINGS Michael Glaesemann grzm myrealbox com