> I would like to know how can i move from 1 database to another one ? > > basically i want to run a *.sql script in which i connect under a > particular database (for example : template1 or postgres) and my *.sql > script should create a new database (for example : test) and after > execute several SQL command under test database.
I guess you are asking how to connect to a new database in the middleof a sql script
Assuming the script will be run by psql, you can use \connect test
gnari
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives?