| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | archie(at)netg(dot)se (Archibald Zimonyi) |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Double quotes? |
| Date: | 2002-07-08 12:54:00 |
| Message-ID: | 200207081054.MAA03734@rodos |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Mathis | 2002-07-08 13:24:18 | Variables in PSQL |
| Previous Message | Bruno Wolff III | 2002-07-08 12:40:13 | Re: INSERT only under certain conditions (SELECT) |