Re: move from 1 database to another

On Thu, May 25, 2006 at 05:41:34PM -0500, Jim Nasby wrote:
> On May 25, 2006, at 1:52 PM, P.M wrote:
> >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.
>
> CREATE DATABASE new_database TEMPLATE = database_to_copy;
> -- Insert additional SQL here...

I wonder if the OP is looking for "\c new_database".

--
Michael Fuhr