From: | "Saltsgaver, Scott" <scottsa(at)aiinet(dot)com> |
---|---|
To: | "Pgsql-Sql (E-mail)" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Creating tables from within functions |
Date: | 2000-06-27 16:17:20 |
Message-ID: | 7283DE19D141D111AD0E00A0C95B195502488A93@mail2.aiinet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Is it possible to issue a CREATE TABLE statement from inside of a PostgreSQL
function? If not, then how about from within a PL/pgSQL function? I have
tried a lot of different permutations but can't seem to get it to compile
and/or run cleanly. For example, consider:
CREATE FUNCTION _testcreate () RETURNS text AS '
BEGIN
CREATE TABLE switch_table2 (switch_id varchar(32),
selection_name varchar(100));
end;
' language 'plpgsql';
What is wrong with this? What type should be returned? Or perhaps it is
simply not possible to create a table from within a function?
Thanks!
Scott Saltsgaver
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Bradetich | 2000-06-27 16:27:22 | Problem with pg_dumpall |
Previous Message | Bryan White | 2000-06-27 16:17:11 | Re: Backup? |