Matt,
> But when I run it, I get the following error.
>
> WARNING: plpgsql: ERROR during compile of sp_newtable near line 8
> ERROR: $1 is declared CONSTANT
You can't use a variable in place of an object name, unless you execute the
query as a dynamic string, e.g.:
CREATE FUNCTION new_table(TEXT) returns INT as
'DECLARE tbname ALIAS for $1;
BEGIN
EXECUTE 'SELECT * INTO ' || newtable || ' FROM d_master';
RETURN 1;
END;' LANGUAGE plpgsql;
--
-Josh Berkus
Aglio Database Solutions
San Francisco