Re: move from 1 database to another - Mailing list pgsql-general

From Ragnar
Subject Re: move from 1 database to another
Date
Msg-id 1148597676.8566.17.camel@localhost.localdomain
Whole thread Raw
In response to move from 1 database to another  ("P.M" <pmdanger@yahoo.com>)
Responses Re: move from 1 database to another  ("P.M" <pmdanger@yahoo.com>)
List pgsql-general
On fim, 2006-05-25 at 11:52 -0700, 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.

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



pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: move from 1 database to another
Next
From: Francisco Reyes
Date:
Subject: Status of gist locking in 8.1.3?