From: Olleg Samojlov <olleg@telecom.mipt.ru>
Subject: Re: create databases with plpgsql
Date: Thu, 10 Apr 2003 13:14:55 +0400
Organization: MIPT Telecom
Lines: 39
Message-ID: <b73cmd$2bpo$2@news.hub.org>
References: <3E929C3D.3010704@hsw.fhz.ch>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
In-Reply-To: <3E929C3D.3010704@hsw.fhz.ch>
To: pgsql-sql@postgresql.org

As I can now create database is none transactional statment. But 
function performed only in transaction. So not. Bu I can mistake.

sirius wrote:
> a novice has the following challenge (problem):
> 
> I would like to create a certain number of new databases named stud01, 
> stud02...to stud25 with a plpgsql-script. But I have difficulties to 
> create a new database with a script. I saw a lot of different scripts in 
> the manuals to create tables, but no new db.
> 
> Generally, is it possible at all? Do you may have any suggestions, 
> workarounds, ideas?
> 
> any help will be appreciated...
> 
> I tried the these simple script without any loop, unfortunately without 
> success:
> 
> create or replace function createDB(text) returns text as '
> DECLARE
>    DBname ALIAS FOR $1;
>    sqlquery text;
>    result text;
> BEGIN
>    sqlquery := ''CREATE DATABASE %'', DBname;
>    EXECUTE( sqlquery );
>    RETURN DBname
> END;
> ' language 'plpgsql';
> 
> Thank you for your help
> 
> sirius
> 

-- 
Olleg Samojlov