Double quotes? - Mailing list pgsql-sql

From Archibald Zimonyi
Subject Double quotes?
Date
Msg-id Pine.LNX.4.21.0207081231190.20576-100000@valdez.netg.se
Whole thread Raw
In response to  ("jack" <datactrl@tpg.com.au>)
Responses Re: Double quotes?
List pgsql-sql
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: "jack"
Date:
Subject:
Next
From: Christoph Haller
Date:
Subject: Re: Double quotes?