Re: regarding the apostrophe character

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: surabhi(dot)ahuja <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: regarding the apostrophe character
Date: 2005-11-25 10:47:20
Message-ID: 6DF360EC-CCB9-4429-A1E4-19380071C145@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Nov 25, 2005, at 13:40 , surabhi.ahuja wrote:

> in which version will the use of "Escape string syntax " be
> supported ..

I know they work in 8.1. You can check the release notes:

http://www.postgresql.org/docs/current/interactive/release.html

The SQL standard way of escaping single-quotes is ''.

test=# select version();

version
------------------------------------------------------------------------
----------------------------------------------------------------------
PostgreSQL 8.1.0 on powerpc-apple-darwin8.3.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.0 (GCC) 4.0.0 (Apple Computer, Inc.
build 5026)
(1 row)

test=# select 'foo''s bar' as sql_standard
test-# , e'foo\'s bar' as e_escape
test-# , $$foo's bar$$ as dollar_quote;
sql_standard | e_escape | dollar_quote
--------------+-----------+--------------
foo's bar | foo's bar | foo's bar
(1 row)

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2005-11-25 10:54:41 Re: pg_dump --data-only: is dump ordered to keep foreign-key-relations
Previous Message Oleg Bartunov 2005-11-25 10:32:47 Re: tool for DB design