Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3B3F09FBE25 for ; Fri, 16 Mar 2007 10:08:34 -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 72701-01 for ; Fri, 16 Mar 2007 10:08:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31809.mail.mud.yahoo.com (web31809.mail.mud.yahoo.com [68.142.207.72]) by postgresql.org (Postfix) with SMTP id 8E9129FBE2B for ; Fri, 16 Mar 2007 10:08:26 -0300 (ADT) Received: (qmail 85765 invoked by uid 60001); 16 Mar 2007 13:08:24 -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=sdy8bbqrxCL5GWL8v4sCzwb15rrrN2x6+ji3dVpZqsi2A9TO0wqs5bxu/bLqG8u5QYQ6dxn5vsOaxZxGIMwjS6bH9Qh993Aw4EloMTtuLpARMrwsByILyRHDj13AePuh9HlGKhTVvmDy9GJDDynPSXRsUBA5oLNt5+Ivwv+Www8=; X-YMail-OSG: y4dm5UUVM1mgHXTCE0IVJCEAR9x_W.tTEOyC7fvMbyX8ZjUmeR9Joc4LW6Qee0h2OA-- Received: from [75.84.83.178] by web31809.mail.mud.yahoo.com via HTTP; Fri, 16 Mar 2007 06:08:24 PDT Date: Fri, 16 Mar 2007 06:08:24 -0700 (PDT) From: Richard Broersma Jr Subject: Re: INSERT INTO To: Richard Broersma Jr , Shavonne Marietta Wijesinghe , pgsql-sql@postgresql.org In-Reply-To: <971034.75143.qm@web31814.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <769639.84876.qm@web31809.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.258 tagged_above=0 required=5 tests=AWL, BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, UPPERCASE_50_75 X-Spam-Level: ** X-Archive-Number: 200703/225 X-Sequence-Number: 27863 > INSERT INTO TABLE2 (TE_INDI) VALUES ($SANT'ANGELO LODIGIANO$); My mistake, a single $ will not work you need two like $$: INSERT INTO TABLE2 (TE_INDI) VALUES ($$SANT'ANGELO LODIGIANO$$); Regards, Richard Broersma Jr.