> Select currval('GEN_&TableName')
>
>From the above, I am assuming you did something like:
CREATE SEQUENCE "GEN_&TableName" ...;
and are trying to access this sequence? If so, you actually have to
include the SQL quoted identifier syntax within the text argument to
currval() or nextval(), e.g.
SELECT nextval('"GEN_&TableName"');
With these sorts of identifier-as-argument parameters in Postgres, you
can also include schema-qualification syntax:
SELECT nextval('"My Schema"."GEN_&TableName"');
Karl
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
