Creating tables from within functions

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

Browse pgsql-sql by date

  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?