pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tim Kane <timk@hotgames.com>
To: pgsql-interfaces@postgreSQL.org
Subject: character arrays and quotation
Date: Tue, 08 Feb 2000 18:06:39 +1100
Message-ID: <389FC07F.137BD592@hotgames.com> (raw)

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





Message-ID: <389FC07F.137BD592@hotgames.com>
Permalink:  ../389FC07F.137BD592@hotgames.com/
Also on:    postgresql.org/message-id/389FC07F.137BD592@hotgames.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: timk@hotgames.com
  Subject: Re: character arrays and quotation
  In-Reply-To: <389FC07F.137BD592@hotgames.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox