arrays of varchar and " - Mailing list pgsql-interfaces

From Tim Kane
Subject arrays of varchar and "
Date
Msg-id 38B5C4AA.A84809F2@hotgames.com
Whole thread Raw
Responses Re: [INTERFACES] arrays of varchar and "  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
I don't recall seeing a response to this, so I'm posting it again.
Sorry if you've seen this twice!
(Assuming my original post made it here anyway).

I have.   create table my_table (       varchar    stuff[];            # An array of varchar   };


I want to insert a number of array elements here...
   insert into my_table values ('{"value 1", "value 2", "value 3"}');

Fine.

What do I do however, when I want to insert an array element that
contains a " character?
It seems I am unable to escape it it like \" as I normally would for a '
character.

Instead, the parser seems to chop out a portion of the query string...

Known bug?
Is there a workaround?

Thanks Heaps!!

Tim.



pgsql-interfaces by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [INTERFACES] selectecting not null varchars.
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] arrays of varchar and "