[sreelatha]

Hi All,

I m new to postgre sql and this forum,
I have a requirement that when i run a script, it should create a user as well as a database. And i want to run my script as a .psql script so that i can run on any platform.
I m able to run a scirpt which has the tabel creation, but i failed do the db and user creations.

Pls reply if any one of u have idea, its urgent.

thanks and regards
sree

[amthomas]

what have you tried? can we see?

creating roles/dbs over and over seems a bit odd :/

you can do this:
psql template1 < dostuff.sql

to run a script on a db which could include db creation.