Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ECFFD9FB5B8; Mon, 4 Jun 2007 17:10:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 32735-05; Mon, 4 Jun 2007 17:10:49 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from buniche.hst.terra.com.br (buniche.hst.terra.com.br [200.176.10.197]) by postgresql.org (Postfix) with ESMTP id 7A8BE9FB4E4; Mon, 4 Jun 2007 17:10:50 -0300 (ADT) Received: from peguis.hst.terra.com.br (peguis.hst.terra.com.br [200.176.10.32]) by buniche.hst.terra.com.br (Postfix) with ESMTP id 391523DD80D4; Mon, 4 Jun 2007 17:10:48 -0300 (BRT) X-Terra-Karma: -2% X-Terra-Hash: ee38dbb6198a3a1eb29215ad4faafc1c Received-SPF: pass (peguis.hst.terra.com.br: domain of terra.com.br designates 200.176.10.32 as permitted sender) client-ip=200.176.10.32; envelope-from=ranieri.oliveira@terra.com.br; helo=[172.16.2.72]; Received: from [172.16.2.72] (200-162-219-207.corp.ajato.com.br [200.162.219.207]) (authenticated user ranieri.oliveira) by peguis.hst.terra.com.br (Postfix) with ESMTP id 78BE52C099; Mon, 4 Jun 2007 17:10:47 -0300 (BRT) Message-ID: <466471C8.40506@terra.com.br> Date: Mon, 04 Jun 2007 17:10:48 -0300 From: Ranieri Mazili User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Inserting a path into Database Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.753 tagged_above=0 required=5 tests=AWL=-0.156, BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708 X-Spam-Level: * X-Archive-Number: 200706/352 X-Sequence-Number: 115175 Hello, I need to insert a path into a table, but because "\" I have a error by postgres, so how can I insert a path like bellow into a table: insert into production values ('C:\Program Files\My program'); I appreciate any help Thanks