Have you ever tried creating a sequence with an apostrophes in its name in PostgreSQL?

Easily, and don't forget about schema qualification either:

test=# create sequence "isn't this ""grand""?";
CREATE SEQUENCE
test=# \ds
                 List of relations
 Schema |        Name         |   Type   |  Owner
--------+---------------------+----------+---------
 public | isn't this "grand"? | sequence | chriskl
(1 row)

test=# select nextval('"isn''t this ""grand""?"');
 nextval
---------
       1
(1 row)

test=# select currval('"isn''t this ""grand""?"');
 currval
---------
       1
(1 row)

test=# select currval('"public"."isn''t this ""grand""?"');
 currval
---------
       1
(1 row)

Chris

--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to