Double quotes?

From: Archibald Zimonyi <archie(at)netg(dot)se>
To: pgsql-sql(at)postgresql(dot)org
Subject: Double quotes?
Date: 2002-07-08 10:35:07
Message-ID: Pine.LNX.4.21.0207081231190.20576-100000@valdez.netg.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • at 2002-07-08 08:11:26 from jack

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Archibald Zimonyi 2002-07-08 10:58:51 Re: Double quotes?
Previous Message Rajesh Kumar Mallah. 2002-07-08 08:12:39 Re: INSERT only under certain conditions (SELECT)