Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 570CE475A13
	for <pgsql-sql@postgresql.org>; Mon,  8 Jul 2002 06:54:07 -0400 (EDT)
Mailbox-Line: From ch@rodos.fzk.de  Mon Jul  8 06:54:07 2002
Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52])
	by postgresql.org (Postfix) with SMTP id E9130475A09
	for <pgsql-sql@postgresql.org>; Mon,  8 Jul 2002 06:54:05 -0400 (EDT)
Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ;
 Mon Jul 08 12:54:01 2002 +0200
Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id MAA02335; Mon, 8 Jul 2002 12:54:00 +0200 (METDST)
From: Christoph Haller <ch@rodos.fzk.de>
Message-Id: <200207081054.MAA03734@rodos>
Subject: Re: Double quotes?
To: archie@netg.se (Archibald Zimonyi)
Date: Mon, 08 Jul 2002 12:54:00 METDST
Cc: pgsql-sql@postgresql.org
In-Reply-To: <Pine.LNX.4.21.0207081231190.20576-100000@valdez.netg.se>;
	from "Archibald Zimonyi" at Jul 8, 102 12:44 (noon)
X-Mailer: Elm [revision: 212.4]
X-Spam-Status: No, hits=-1.7 required=5.0
	tests=IN_REP_TO,SUBJ_ENDS_IN_Q_MARK,INVALID_DATE,PORN_12,PORN_10
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/85
X-Sequence-Number: 8464

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
>