On Fri, 22 Aug 2003, Godshall Michael wrote:
You probably need to use EXECUTE.
EXECUTE ''DROP TABLE '' || random_table_name;
...
EXECUTE ''CREATE TABLE '' || random_table_name || ...
or
EXECUTE ''CREATE TEMP TABLE '' || random_table_name || ...
If you want to use the table from another function,
I think you'll probably need to wrap the uses of it
with EXECUTE in those functions as well. Or you might
be better off in another pl language (maybe pltcl or
plpython) because plpgsql caches the query plans and
gets somewhat confused when tables not used in EXECUTE
are dropped between calls.