Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C38469FB7A9 for ; Mon, 4 Jun 2007 17:45:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 36720-10 for ; Mon, 4 Jun 2007 17:45:06 -0300 (ADT) X-Greylist: delayed 00:05:03.888102 by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.186]) by postgresql.org (Postfix) with ESMTP id D8F269FB274 for ; Mon, 4 Jun 2007 17:45:09 -0300 (ADT) Received: from [90.187.54.157] (helo=mario-laptop.havelsoft-local.com) by mrelayeu.kundenserver.de (node=mrelayeu0) with ESMTP (Nemesis), id 0MKwh2-1HvJLL44oh-0004C6; Mon, 04 Jun 2007 22:40:02 +0200 Received: from guenti by mario-laptop.havelsoft-local.com with local (Exim 4.62) (envelope-from ) id 1HvJKl-0005qA-CL for pgsql-general@postgresql.org; Mon, 04 Jun 2007 22:39:23 +0200 Date: Mon, 4 Jun 2007 22:39:23 +0200 From: Mario Guenterberg To: pgsql-general@postgresql.org Subject: Re: Inserting a path into Database Message-ID: <20070604203923.GA22350@/bin/dnsdomainname> Reply-To: pgsql-general@postgresql.org Mail-Followup-To: pgsql-general@postgresql.org References: <466471C8.40506@terra.com.br> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="sm4nu43k4a2Rpi4c" Content-Disposition: inline In-Reply-To: <466471C8.40506@terra.com.br> Organization: havelsoft.com X-Operating-System: GNU/Linux (Kernel 2.6.20.10-mg1) X-PGP-Key: http://www.havelsoft.com/misc/mg_pubkey.asc User-Agent: Mutt/1.5.15 (2007-04-06) X-Provags-ID: V01U2FsdGVkX19aPegqeg23YO/sXCv07ogzhA1ttcYvbEa+2Za ww/aLm9jPVNiIUnD94S0w+91el1m1oJXm3RrwGyc7e4cDppC8d 995ntkC5oRH0n+s95Ma+Q== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.162 tagged_above=0 required=5 tests=AWL=0.026, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/354 X-Sequence-Number: 115177 --sm4nu43k4a2Rpi4c Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Jun 04, 2007 at 05:10:48PM -0300, Ranieri Mazili wrote: > Hello, >=20 > I need to insert a path into a table, but because "\" I have a error by= =20 > postgres, so how can I insert a path like bellow into a table: >=20 > insert into production values ('C:\Program Files\My program'); >=20 Use double quotes. In example c:\\Programme Files\\... Greetings --=20 ----------------------------------------------------- | havelsoft.com - Ihr Service Partner f=FCr Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com | | | | Inhaber: Mario G=FCnterberg | | M=FCtzlitzer Strasse 19 | | 14715 M=E4rkisch Luch | ----------------------------------------------------- --sm4nu43k4a2Rpi4c Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iQIVAwUBRmR4ejUZahlMISn3AQJg5Q/+LCrhIp/ZJW+ynfXuRV/CNTXOJe3u2dlH oRNsSuIQtetr8lhbRIa9XZmx/sniUe3dZ0UZ7nZx8e+qqJKuKl4dkOWpixwiGabQ l98yJMZEiYYSKsDVEjbSZ8fU1iiQ1WZMrHl+KK7WUbrkD8EPmQy+l4mWdlPQZ2F8 fmKZG3IfyDSbhA+CnvCr3IOMmn/0Nxn9t55PoA2LveohKpWcytwTzgaJfKhVYwe5 LkbxzRoQHEyn4ohacqhUx2ekgSZhTpBLfJPeJdU8K91w1PhHRENiJ7tOHtOG9hE5 ckbeqSBxtOgDDH4anmgXaUftJsSHQzyeCdABo/HkGwyvlHQYj+2AMSxm9We65334 LnhLgbNpMjEwgVnAEs9/jDLZQMK2J7BnjNUFtVqPi2kZNyagcgvEKlcdL1il91cV PiTWJdnYfQad/+d4n3WIqtsDl49ABi/KIvD0KAkCVpN4SYGyxudYKaQsSD5Qr5AM J4EUJMrQmrMpWtSoeRiYyewIDcQ14g1C62hhJLB4DqqiK8BoWaDel5OueS/TlVUy fzTV5GVEF9u0l0joXCmHMHXzyUKqQCuUbpHd3zdG/SIqdsaMZd+SR2gsw/CC3esb ghHKZAeA+n+gecD/rmgjaOxwdmRJRmzTXEgOXInU+Fs8Hb1SZMC7z6JwoT8/zOLN 5ayulxagom0= =5JC+ -----END PGP SIGNATURE----- --sm4nu43k4a2Rpi4c--