What characters need to be quoted?

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: What characters need to be quoted?
Date: 2002-09-13 02:03:01
Message-ID: 3D814755.8010508@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Are there any characters besides the single quote that need to be
escaped when inserting into PostgresQL?

And am I right in thinking that the SQL standard calls for putting one
single quote in front of a single quote to escape it (and not use a
backslash as some other DBs would have you do?)

Thanks

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-09-13 03:20:46 Re: Mailing lists archive search
Previous Message Justin Hawkins 2002-09-13 01:03:33 OID order = INSERT order?