> 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