On Tuesday 13 April 2004 08:40, Tumurbaatar S. wrote:
> Hi!
> I cannot imagine how to create db from a script file and execute
> other DDL statements on this new db.
> P.S. Some RDBMS automatically switches to a newly created db
> after 'CREATE DATABASE' and some other languages have command
> like 'USE' to switch to a different db.
You want to look into the "\c" command available in psql. That reconnects to a
different db / user.
Worth doing a pg_dump (text format) and looking at its output (or pg_restore
to a text-file).
--
Richard Huxton
Archonet Ltd