Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 5D5899FB7C3
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Feb 2007 12:54:27 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 21132-04-3 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 26 Feb 2007 12:54:10 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.239])
	by postgresql.org (Postfix) with ESMTP id 3F89A9FB793
	for <pgsql-sql@postgresql.org>; Mon, 26 Feb 2007 12:54:10 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so1457760wxd
	for <pgsql-sql@postgresql.org>; Mon, 26 Feb 2007 08:54:09 -0800 (PST)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:x-mimeole:thread-index;
	b=lW6iPuT6Ba2cTrNYiKqKgZsb6qEG3GY8FGrd0n8QWJoAd1xKsACe64899DGFL24lJrMjNIy8JbttbWO4PCqh2465NgbuWms5MTdWOHOuaO7Rlt/cKP2cyvTPc3oTomIDWKL5VWsnVIyEFGFhnGni13avVkR90dLZ7+nJgOaUWag=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:x-mimeole:thread-index;
	b=Ahz/OgobTbihHG0q4nQRKA/6z86vuStM5cFtag/TEZy+R+COQHnS4WP+al1HTosiL/z3gVywzz2RRm6lY6Ij4e+wyZRexk4L0gihII5vk000kTta4dNPOAzoMla0yuCiH7CAZIlUzP8zvbxTMLEo9A1qKxzLpj1siJ5M0NyIV8M=
Received: by 10.90.56.14 with SMTP id e14mr4959918aga.1172508849658;
	Mon, 26 Feb 2007 08:54:09 -0800 (PST)
Received: from mis06 ( [205.214.220.146])
	by mx.google.com with ESMTP id j4sm6012954nzd.2007.02.26.08.53.57;
	Mon, 26 Feb 2007 08:54:09 -0800 (PST)
From: "Rommel the iCeMAn" <icecrew@gmail.com>
To: <pgsql-sql@postgresql.org>
Subject: Change Default Database
Date: Mon, 26 Feb 2007 12:52:19 -0400
Message-ID: <008401c759c6$81bef2c0$b364a8c0@theport.com>
MIME-Version: 1.0
Content-Type: multipart/related;
	boundary="----=_NextPart_000_0085_01C759A4.FAAD52C0"
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
Thread-Index: AcdZxnVzN5WxP4cOSe24Dq7GN3Z65A==
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/265
X-Sequence-Number: 27599

This is a multi-part message in MIME format.

------=_NextPart_000_0085_01C759A4.FAAD52C0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_0086_01C759A4.FAAD52C0"


------=_NextPart_001_0086_01C759A4.FAAD52C0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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.
 

------=_NextPart_001_0086_01C759A4.FAAD52C0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<STYLE>
<!--
P.msoNormal, LI.msoNormal
{
font-family: "MS Sans Serif", "sans serif";
font-weight: normal;
font-size: 12pt;
color: black;
margin:0in;
margin-bottom:.0001pt;
}

body
{
font-family: "MS Sans Serif", "sans serif";
font-weight: normal;
font-size: 12pt;
color: black;
margin-left: 50px;
}

HR
	{
	color: "#00FFFF";
	width: 100%;
	height: 1px;
	}
-->
</STYLE>

<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR></HEAD>
<BODY bgColor=3D#ffffff background=3Dcid:188014716@26022007-10BD>
<DIV><SPAN class=3D188014716-26022007><FONT face=3D"Comic Sans MS" =
size=3D2>Hi=20
list,</FONT></SPAN></DIV>
<DIV><SPAN class=3D188014716-26022007><FONT face=3D"Comic Sans MS"=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D188014716-26022007><FONT face=3D"Comic Sans MS" =
size=3D2>I wrote a=20
database creation script that&nbsp;begins with&nbsp;commands to drop the =

existing database (if it exists) and create it from scratch. These =
commands=20
execute fine, the problem is that all subsequent commands are executed =
on the=20
default database 'postgres'. What command can I use to set the default =
database=20
to&nbsp;my newly created database (for the duration of the script)? SQL =
Server=20
has a 'USE [dbname]' command, is there an equivalent command in=20
PostgreSQL?</FONT></SPAN></DIV>
<DIV><SPAN class=3D188014716-26022007><FONT face=3D"Comic Sans MS"=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D188014716-26022007><FONT face=3D"Comic Sans MS" =
size=3D2>Thanks in=20
advance,</FONT></SPAN></DIV>
<DIV><SPAN class=3D188014716-26022007>
<DIV align=3Dleft><FONT face=3D"Comic Sans MS" size=3D2>Rommel =
Edwards</FONT></DIV>
<DIV align=3Dleft><FONT face=3D"Comic Sans MS" size=3D2>Software=20
Developer,</FONT></DIV>
<DIV align=3Dleft><FONT face=3D"Comic Sans MS" size=3D2>Barbados,=20
Caribbean.</FONT></DIV></SPAN></DIV>
<DIV><SPAN class=3DSpellE><SPAN class=3DGramE><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'; =
mso-bidi-font-family: Arial"></SPAN></SPAN></SPAN><SPAN=20
style=3D"FONT-FAMILY: 'Comic Sans MS'"><?xml:namespace prefix =3D o ns =
=3D=20
"urn:schemas-microsoft-com:office:office"=20
/><o:p></o:p></SPAN>&nbsp;</DIV></BODY></HTML>

------=_NextPart_001_0086_01C759A4.FAAD52C0--

------=_NextPart_000_0085_01C759A4.FAAD52C0
Content-Type: image/jpeg;
	name="Notebook.jpg"
Content-Transfer-Encoding: base64
Content-ID: <188014716@26022007-10BD>

/9j/4AAQSkZJRgABAgEASABIAAD/7QSyUGhvdG9zaG9wIDMuMAA4QklNA+kAAAAAAHgAAwAAAEgA
SAAAAAADBgJS//f/9wMPAlsDRwUoA/wAAgAAAEgASAAAAAAC2AIoAAEAAABkAAAAAQADAwMAAAAB
Jw8AAQABAAAAAAAAAAAAAAAAYAgAGQGQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4
QklNA+0AAAAAABAASAAAAAEAAQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoAAAAA
AAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2ZmAAEAbGZmAAYAAAAAAAEA
L2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYAAAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklN
A/gAAAAAAHAAAP////////////////////////////8D6AAAAAD/////////////////////////
////A+gAAAAA/////////////////////////////wPoAAAAAP//////////////////////////
//8D6AAAOEJJTQQAAAAAAAACAAA4QklNBAIAAAAAAAIAADhCSU0ECAAAAAAAEAAAAAEAAAJAAAAC
QAAAAAA4QklNBAkAAAAAAqIAAAABAAAAgAAAAAIAAAGAAAADAAAAAoYAGAAB/9j/4AAQSkZJRgAB
AgEASABIAAD//gAnRmlsZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcKggNC4wAP/uAA5BZG9i
ZQBkgAAAAAH/2wCEAAwICAgJCAwJCQwRCwoLERUPDAwPFRgTExUTExgRDAwMDAwMEQwMDAwMDAwM
DAwMDAwMDAwMDAwMDAwMDAwMDAwBDQsLDQ4NEA4OEBQODg4UFA4ODg4UEQwMDAwMEREMDAwMDAwR
DAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDP/AABEIAAIAgAMBIgACEQEDEQH/3QAEAAj/xAE/
AAABBQEBAQEBAQAAAAAAAAADAAECBAUGBwgJCgsBAAEFAQEBAQEBAAAAAAAAAAEAAgMEBQYHCAkK
CxAAAQQBAwIEAgUHBggFAwwzAQACEQMEIRIxBUFRYRMicYEyBhSRobFCIyQVUsFiMzRygtFDByWS
U/Dh8WNzNRaisoMmRJNUZEXCo3Q2F9JV4mXys4TD03Xj80YnlKSFtJXE1OT0pbXF1eX1VmZ2hpam
tsbW5vY3R1dnd4eXp7fH1+f3EQACAgECBAQDBAUGBwcGBTUBAAIRAyExEgRBUWFxIhMFMoGRFKGx
QiPBUtHwMyRi4XKCkkNTFWNzNPElBhaisoMHJjXC0kSTVKMXZEVVNnRl4vKzhMPTdePzRpSkhbSV
xNTk9KW1xdXl9VZmdoaWprbG1ub2JzdHV2d3h5ent8f/2gAMAwEAAhEDEQA/APROif0Kv6X81T9L
j+ar/m/5K0F8rJJIfqlJfKySKn6pSXyskkp+qUl8rJJKfqlJfKySSn6pSXyskkp+qUl8rJJKfqlJ
fKySSn//2ThCSU0EBgAAAAAABwABAAAAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBBZG9iZSBQaG90
b3Nob3CoIDQuMAD/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgNCQ0VDAwVGhQQFBogGxoaGyAiFxcX
FxciEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMAQ0NDREOERsRERsUDg4OFBQO
Dg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAYBaAD
ASIAAhEBAxEB/90ABABa/8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEB
AQAAAAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVBUWETInGBMgYU
kaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRFwqN0NhfSVeJl8rOEw9N14/NGJ5Sk
hbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQAC
EQMhMRIEQVFhcSITBTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RF
VTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dnd4eXp7fH/9oADAMB
AAIRAxEAPwCv0T+n4/8AxrP+qavW15J0U/r+P/xrP+qavWg8eKElsWSHZfXWYe4A+ZUMjIFTJBE/
Fc1kXbg63mJP+amk0uesGqdc19Sup2ZrLmWGQxwLR4B35v8A0V0qKlJJJIqUkkkkpSSSSSlJJJJK
UkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSS
SSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJ
KUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpS
SSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJ
JKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkp
SSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJ
JJKUkkkkpSSSSSn/0J9G6oKn04zKKXOdYA6x7d1kOP8Ag/3Hs/MXY/sOl/0hYfCT/wCQavnZJArQ
/S1HTXVN21+weYa7/vqzcroeQ+Q3XcYOn/mbF89pIaJfpboXRK+k1uDQPUsILyONPotZ/JatRfKq
SSX6qSXyqkip+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp
JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl
8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy
qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq
SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn/2Q==

------=_NextPart_000_0085_01C759A4.FAAD52C0--