Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id BF6A59FB6C7
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 10:02:44 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 44363-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 16 Mar 2007 10:02:27 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web31814.mail.mud.yahoo.com (web31814.mail.mud.yahoo.com
	[68.142.206.167])
	by postgresql.org (Postfix) with SMTP id 2088A9FB684
	for <pgsql-sql@postgresql.org>; Fri, 16 Mar 2007 10:02:32 -0300 (ADT)
Received: (qmail 75431 invoked by uid 60001); 16 Mar 2007 13:02:30 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=B26nY9jWKbEu9k5W9CcEWlfNKLpHiszL63pbQI54/xleD2AFPmDbRjsjyJN4BWmsx6p7l4si/2++otjilVquzdFBPosOcXlh15FphQ4npg7xZoDgnD97slhX0LPtxCBr5r7O9BDH3C7Bf1jwChafCIwShOAWR9F3EbNEYdUROMg=;
X-YMail-OSG: 
 E1goVLsVM1k7He_JUmluq6gml2ck8UzXrwG0PBfwygHx3V3H_qGooHXQ3tkMQQdEyOkCwJzULgbehWnXJFIL1gmt7OHfw2d5Dui99kIUiiVeWieZMoa658DO.uSgMBx.12XvxtkGqCsRQng-
Received: from [75.84.83.178] by web31814.mail.mud.yahoo.com via HTTP;
	Fri, 16 Mar 2007 06:02:29 PDT
Date: Fri, 16 Mar 2007 06:02:29 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: INSERT INTO
To: Shavonne Marietta Wijesinghe <shavonne.marietta@studioform.it>,
	pgsql-sql@postgresql.org
In-Reply-To: <002c01c767a8$20d5d600$1102a8c0@dream>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <971034.75143.qm@web31814.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.627 tagged_above=0 required=5 tests=AWL, BAYES_50,
	UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200703/224
X-Sequence-Number: 27862

> When i have a string that has a ' inside of it the record is not inserted in to TABLE2. I know
> that writing it twice will fix it but how can i ask my ASP code to do it..
> 
> INSERT INTO TABLE2 (TE_INDI) VALUES ('SANT'ANGELO LODIGIANO');

If you are using PostgreSQL >= 8.0 you can use dollars sign quoting like the following:

INSERT INTO TABLE2 (TE_INDI) VALUES ($SANT'ANGELO LODIGIANO$);

or even a custom quotation identifier:

INSERT INTO TABLE2 (TE_INDI) VALUES ($myquote$SANT'ANGELO LODIGIANO$myquote$);

Would this work in ASP?

Regards,
Richard Broersma Jr.