pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Re: Double quotes?
3+ messages / 2 participants
[nested] [flat]

* Re: Double quotes?
@ 1970-01-01 00:00  Christoph Haller <ch@rodos.fzk.de>
  parent: Archibald Zimonyi <archie@netg.se>
  0 siblings, 1 reply; 3+ messages in thread

From: Christoph Haller @ 1970-01-01 00:00 UTC (permalink / raw)
  To: archie@netg.se; +Cc: 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
> 





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Double quotes?
@ 2002-07-08 10:35  Archibald Zimonyi <archie@netg.se>
  0 siblings, 1 reply; 3+ messages in thread

From: Archibald Zimonyi @ 2002-07-08 10:35 UTC (permalink / raw)
  To: 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







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Double quotes?
@ 2002-07-08 10:58  Archibald Zimonyi <archie@netg.se>
  parent: Christoph Haller <ch@rodos.fzk.de>
  0 siblings, 0 replies; 3+ messages in thread

From: Archibald Zimonyi @ 2002-07-08 10:58 UTC (permalink / raw)
  To: 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. 
> 
Found the problem. Yes I enclosed the text in single quotes, and the text
also included a single quote that I managed to miss to escape.

Thanks anyway,

Archie







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2002-07-08 10:58 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-08 10:35 Double quotes? Archibald Zimonyi <archie@netg.se>
1970-01-01 00:00 ` Christoph Haller <ch@rodos.fzk.de>
2002-07-08 10:58   ` Archibald Zimonyi <archie@netg.se>

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