Re: Executing script file

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