create new table

From: Tamas Kohegyi <tkohegyi(at)gw(dot)consultronics(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: create new table
Date: 1999-06-22 13:32:21
Message-ID: 376F9065.A15A9BE@gw.cdk.bme.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I have to create a table in a function, but i know the name of the new
table inside the fuction only.
How can I do this? (PL/PgSQL)

e.g.:
---------------------------
DECLARE a text;
...
BEGIN
a := 'newdb';
...
CREATE TABLE a (...);
...
------------------------------

-> parse error at or near "$1"
So it does not work...

Any idea?

Thanks,
Tamas

Browse pgsql-sql by date

  From Date Subject
Next Message tkohegyi 1999-06-22 13:33:44 create new table
Previous Message Luiz Renuncio 1999-06-22 13:11:46 Sharing a user defined type