character arrays and quotation

From: Tim Kane <timk(at)hotgames(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: character arrays and quotation
Date: 2000-02-08 07:06:39
Message-ID: 389FC07F.137BD592@hotgames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas Lockhart 2000-02-08 07:13:31 Re: [INTERFACES] Bug in parser?
Previous Message Tom Lane 2000-02-08 06:42:13 Re: [INTERFACES] Bug in parser?