Received: from gw.consultronics.hu (root@gw.cdk.bme.hu [152.66.10.1]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA28139 for ; Tue, 22 Jun 1999 09:32:28 -0400 (EDT) (envelope-from tkohegyi@gw.cdk.bme.hu) From: tkohegyi@gw.cdk.bme.hu Received: from tkohegyi (really [192.168.41.63]) by gw.cdk.bme.hu via in.smtpd with smtp id (Debian Smail3.2.0.102) for ; Tue, 22 Jun 1999 15:33:29 +0200 (CEST) Message-Id: To: pgsql-sql@postgresql.org Date: Tue, 22 Jun 1999 15:33:44 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: create new table X-Confirm-Reading-To: tkohegyi@gw.cdk.bme.hu X-pmrqc: 1 Priority: normal X-mailer: Pegasus Mail for Win32 (v3.11) 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@gw.cdk.bme.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@gw.cdk.bme.hu |