CREATE SCHEMA $1?

From: wtf <wtf(at)despammed(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE SCHEMA $1?
Date: 2003-11-28 18:01:00
Message-ID: Xns9441C1A6C9339wtf@193.70.192.192
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I to create schema with arbitrary name but it seems CREATE SCHEMA doesn't
accept anythig different from a constant as an argument. I've tried with a
function (CREATE SCHEMA some_func();), a SELECT (CREATE SCHEMA (SELECT
somename FROM sometable);) or as a function (CREATE SCHEMA $1; inside a
function definition) but the parser always throw an error at the first
carachter after "SCHEMA".

I can make a little perl script to make the work, but I assume I'm just
missing a bit somewhere...any hint?

I'm using postgres 7.3.2 (on a debian sarge, r1-5).

--
wtf

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-11-28 18:40:14 Re: Postgresql on file system EXT2 or EXT3
Previous Message Joshua D. Drake 2003-11-28 17:22:39 Re: Postgresql on file system EXT2 or EXT3