On 2014-09-19 11:04:36 +0000, hubert depesz lubaczewski said:
On Fri, Sep 19, 2014 at 8:35 AM, Philipp Kraus <philipp.kraus@xxxxxxxxxxxx> wrote:
Is there a buildin way to clone the "database_source" with all structure and data into a new database "database1..150" ?
assuming you're using bash shell, this should work:
for i in {1..150}; do createdb -T database_source database$i; done
it's not a built-in, but very close.
depesz
Thanks this is nice, to define a template and run the shell script
Thanks a lot
Phil