character arrays and quotation - Mailing list pgsql-interfaces

From Tim Kane
Subject character arrays and quotation
Date
Msg-id 389FC07F.137BD592@hotgames.com
Whole thread Raw
List pgsql-interfaces
Is it at all possible to INSERT into an array of string types a value
that contains quotation marks (")?

I've tried escaping the " as \" but it doesn't seem to help...

eg:   INSERT into my_table VALUES ('{"value_1","value_2","quote\"doesnt
work\" damn","value_4"}');


Any thoughts?

Thanks heaps,

Tim Kane




pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Bug in parser?
Next
From: Thomas Lockhart
Date:
Subject: Re: [INTERFACES] Bug in parser?