I am looking to automate and simplify the creation of new, empty tables
from a template.
I'm running PostgreSQL 7.3.4 under Fedora Core 1.
CREATE OR REPLACE FUNCTION sp_newtable(TEXT) RETURNS VOID AS '
newtable ALIAS FOR $1;
SELECT * INTO newtable FROM d_master WHERE False;
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
Any tips? I've hammered on this thing for awhile now...
pgsql-novice by date
|Next:||From: Rob Mosher||Date: 2004-02-05 02:33:28|
|Subject: Re: Inserting a Null date.|
|Previous:||From: Bantamess||Date: 2004-02-04 17:51:44|
|Subject: Dual Primary Keys|