Postgres Pro
Downloads
Home   >   mailing lists

Thread: move from 1 database to another

move from 1 database to another

From
"P.M"
Date:
Hi,

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.

thanks a lot,

Maileen

Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.

Re: move from 1 database to another

From
Jim Nasby
Date:
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...

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: move from 1 database to another

From
Michael Fuhr
Date:
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

Re: move from 1 database to another

From
Ragnar
Date:
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

Re: move from 1 database to another

From
"P.M"
Date:
Thanks.
it works well.

Ragnar <gnari@hive.is> wrote:
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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.