Rommel the iCeMAn wrote:
Hi list,
I wrote a database creation script that begins with commands to drop the
existing database (if it exists) and create it from scratch. These commands
execute fine, the problem is that all subsequent commands are executed on
the default database 'postgres'. What command can I use to set the default
database to my newly created database (for the duration of the script)? SQL
Server has a 'USE [dbname]' command, is there an equivalent command in
PostgreSQL?
See "man psql" (or the client applications section of the manuals) for
details on the backslash commands. \c will be what you're after.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
