Thread: create databases with plpgsql

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

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