| 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: | Whole Thread | Raw Message | 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? |