create new table

From: tkohegyi(at)gw(dot)cdk(dot)bme(dot)hu
To: pgsql-sql(at)postgresql(dot)org
Subject: create new table
Date: 1999-06-22 13:33:44
Message-ID: m10wQg5-000BdLC@gw.consultronics.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
e-mail: tkohegyi(at)gw(dot)cdk(dot)bme(dot)hu

| T a m a s K o h e g y i | H-1111 Budapest, Muegyetem rkp. 3|
| Consultronics Development Ltd. | BME, building D. 1st floor |
| HUNGARY | Tel: +36 (1) 372 0580 |
| http://www.consultronics.com | E-mail: tkohegyi(at)gw(dot)cdk(dot)bme(dot)hu |

Browse pgsql-sql by date

  From Date Subject
Next Message Luiz Renuncio 1999-06-22 14:13:35 Sharing a user defined type
Previous Message Tamas Kohegyi 1999-06-22 13:32:21 create new table