[LukeJohnson]

Hello All,

(short background) My company are currently building a small application alongside our main work, we will be using a Postgresql DB.

What I am actually trying to do is a SQL script that loop creates a whole bunch of schemas and names them accordingly.

Something along the lines of:

Create Schema ljschema1
loop until
name = +1

If you catch my drift

so the next one would be called ljschema2 etc. etc.

Thanks in advance, and don't hesitate to tell me if what I am asking is stupid.

[shammat]

Something like this:

do
$body$
declare
  counter integer;
  stmt    text;
begin
  counter := 1;
  loop
    stmt := 'create schema ljschema' || counter::text;
    execute stmt;
    counter := counter + 1;
    exit when counter > 5;
  end loop;
end
$body$;

commit;

For more details please see the manual:

http://www.postgresql.org/docs/curre...ic/sql-do.html
http://www.postgresql.org/docs/curre...c/plpgsql.html

[LukeJohnson]

Thankyou very much

Great help