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 [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
