From: Christoph Haller <ch@rodos.fzk.de>
To: archie@netg.se
Cc: pgsql-sql@postgresql.org
Subject: Re: Double quotes?
Date: Mon, 08 Jul 2002 12:54:00 METDST
Message-ID: <200207081054.MAA03734@rodos> (raw)
In-Reply-To: <Pine.LNX.4.21.0207081231190.20576-100000@valdez.netg.se>
The information you gave is not very helpful.
An INSERT command, which caused the error, would help.
Anyway, did you enclose the text by single quotes?
AFAIK, you do not have to escape double quotes.
Regards, Christoph
>
> Hi everyone,
>
> I have a column with type text and am trying to pump in a larger amount of
> text that has double quotes and also commas in between. I got an error
> when I tried to do a simple INSERT. I then tried to escape the double
> quote with a backslash but that didn't work. The manual for the 7.1
> database says that I can escape charactes by using the \xxx where xxx is
> the octal value of the character. Is this the only way or have I missed
> out on something simple and just keep making a small mistake?
>
> Thanks in advance,
>
> Archie
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de, archie@netg.se
Subject: Re: Double quotes?
In-Reply-To: <200207081054.MAA03734@rodos>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox