Re: Double quotes? - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Double quotes?
Date
Msg-id 200207081054.MAA03734@rodos
Whole thread Raw
In response to Double quotes?  (Archibald Zimonyi <archie@netg.se>)
Responses Re: Double quotes?  (Archibald Zimonyi <archie@netg.se>)
List 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
> 




pgsql-sql by date:

Previous
From: Archibald Zimonyi
Date:
Subject: Double quotes?
Next
From: Archibald Zimonyi
Date:
Subject: Re: Double quotes?