Re: [SQL] Insert query

On Tue, 14 Jul 1998, Paulo Trezentos wrote:

> Dear Mr. Reader
>
> I would like to insert a tuple in a table. The problem is that one of my
> fields as a " ' ".
>
> The query is like this :
>
> INSERT INTO mytable VALUES ('field1','fiel ' d2');
>
> Is this a bug, or is there another way of inserting that tuple ?

psql for example expects a 6th "'" as end for the string. And it is
completely confused by the result :-)

To insert your obscure tuple, you have to 'escape' the "'".
Just try:

INSERT INTO mytable VALUES ('field1','fiel \' d2');
^^
the "'" is not interpreted as part of the sql-command but interpreted as
part of the string.

So long,
Holger