Re: Inserting a path into Database

From: Mario Guenterberg <mg(at)havelsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inserting a path into Database
Date: 2007-06-04 20:39:23
Message-ID: 20070604203923.GA22350@/bin/dnsdomainname
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Mon, Jun 04, 2007 at 05:10:48PM -0300, Ranieri Mazili wrote:
> 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');
>

Use double quotes. In example c:\\Programme Files\\...

Greetings

--
-----------------------------------------------------
| havelsoft.com - Ihr Service Partner für Open Source |
| Tel: 033876-21 966 |
| Notruf: 0173-277 33 60 |
| http://www.havelsoft.com |
| |
| Inhaber: Mario Günterberg |
| Mützlitzer Strasse 19 |
| 14715 Märkisch Luch |
-----------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2007-06-04 20:52:10 Re: Partitioning (was Re: Slightly OT.)
Previous Message Shoaib Mir 2007-06-04 20:19:11 Re: [SQL] Inserting a path into Database

Browse pgsql-sql by date

  From Date Subject
Next Message Kristo Kaiv 2007-06-04 21:08:28 Re: current_date / datetime stuff
Previous Message Shoaib Mir 2007-06-04 20:19:11 Re: [SQL] Inserting a path into Database