| From: | Jim Nasby <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | P(dot)M <pmdanger(at)yahoo(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: move from 1 database to another |
| Date: | 2006-05-25 22:41:34 |
| Message-ID: | AFFFB652-1374-4583-8075-67CAE8EF9DF7@pervasive.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-05-25 22:50:53 | Re: move from 1 database to another |
| Previous Message | Jim Nasby | 2006-05-25 22:33:25 | Re: Best practice to grant all privileges on all bjects in database? |