Change Default Database

From: "Rommel the iCeMAn" <icecrew(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Change Default Database
Date: 2007-02-26 16:52:19
Message-ID: 008401c759c6$81bef2c0$b364a8c0@theport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Thanks in advance,
Rommel Edwards
Software Developer,
Barbados, Caribbean.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-02-26 16:58:40 Re: Change Default Database
Previous Message T E Schmitz 2007-02-26 12:52:32 Re: pg_dump fails (timestamp out of range)