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 JAA28018 for ; Tue, 22 Jun 1999 09:31:06 -0400 (EDT) (envelope-from tkohegyi@gw.cdk.bme.hu) Received: from gw.cdk.bme.hu (really [192.168.41.63]) by gw.cdk.bme.hu via in.smtpd with esmtp id (Debian Smail3.2.0.102) for ; Tue, 22 Jun 1999 15:32:06 +0200 (CEST) Message-ID: <376F9065.A15A9BE@gw.cdk.bme.hu> Date: Tue, 22 Jun 1999 15:32:21 +0200 From: Tamas Kohegyi X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en,hu MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: create new table Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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