Date: Fri, 13 Jun 2003 08:22:42 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Demidem Mohamed Amine <demidem_amine@yahoo.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: create tables within functions
In-Reply-To: <20030613150743.46827.qmail@web13603.mail.yahoo.com>
Message-ID: <20030613082154.M62271-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Fri, 13 Jun 2003, Demidem Mohamed Amine wrote:

> hello,
>
> Can anyone help me create a function that creates a
> table, in this way for example :

See EXECUTE for a way to execute a query that you've built into
a string, for example, something like:

EXECUTE ''create table '' || $1 || '' (id integer, stuff text)'';

>
> create function create_table(text) returns integer as
> '
> begin
>   create table $1 (id integer, stuff text);
>   return 0;
> end;'
> language plpgsql;
>
> it does not work !!
>
> thnx
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
> http://calendar.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>