Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB27mvm87923 for ; Sun, 2 Dec 2001 02:48:57 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id CFEF6D5E8; Sat, 1 Dec 2001 23:48:57 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C39B35BED; Sat, 1 Dec 2001 23:48:57 -0800 (PST) Date: Sat, 1 Dec 2001 23:48:57 -0800 (PST) From: Stephan Szabo To: Megalex Cc: Subject: Re: problems with single quotes.. In-Reply-To: <000b01c07680$29fb2430$0301a8c0@klanomega.com> Message-ID: <20011201234829.F77227-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/7 X-Sequence-Number: 5830 On Thu, 4 Jan 2001, Megalex wrote: > ok.. here is my deal.. > > everytime i try to run an insert and my text contains '\' > it fails.. > > an sql example would be. > > Insert Into table(userID,FirstName,LastName) values(1,'''\''','test') > and i get this message... > > Error while executing the query; ERROR: parser: parse error at or near > "test" > > how can i fix this?? You'll need to backslash escape that backslash.