Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B05219FB341 for ; Mon, 26 Feb 2007 13:24:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 28016-09 for ; Mon, 26 Feb 2007 13:24:27 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 730429FB31E for ; Mon, 26 Feb 2007 13:24:27 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so863127pye for ; Mon, 26 Feb 2007 09:24:26 -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:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index; b=TMmkJxReX/biz3wxC7eb3yR+wVa9wl4pHBlLPaN8pah05iW90MGtQsx09B7viGlMvojwX1w3Tweqn6x6FOypX2yAXSfsHVVnxPA10uhpkfy4pj5KmkCAcYcWR5JujlNuYyCrFuCLR2WxOjFMA6vDVMBaT2yNXVO2VHAVTR6LoC4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index; b=sQMELSIR5MGiB+zdDDxR5z+/RHSq7tPn2hG5SIRgsPg+qHcHYP2v3YbFfBx3K+bWAtCbdM+sgUvIHCNDUiaZnj9uYRxQ3liM2+ML7XW1GZlrfuuZNzhybITzP5jWp3hvkzxU15sYomH6o6s9MkETR5inyEpdx+YA9XEwoafMioU= Received: by 10.35.58.8 with SMTP id l8mr12449206pyk.1172510666727; Mon, 26 Feb 2007 09:24:26 -0800 (PST) Received: from mis06 ( [205.214.220.146]) by mx.google.com with ESMTP id e1sm6065487nzd.2007.02.26.09.24.25; Mon, 26 Feb 2007 09:24:26 -0800 (PST) From: "Rommel the iCeMAn" To: Subject: Re: Change Default Database Date: Mon, 26 Feb 2007 13:22:54 -0400 Message-ID: <008d01c759ca$c131a2f0$b364a8c0@theport.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 Thread-Index: AcdZyWTukV2ITBCUQXWLjfmOUUDD7gAAHx7A X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/268 X-Sequence-Number: 27602 Thanks for the swift responses, I tried the \c command but I got the following error: ERROR: syntax error at or near "\" SQL state: 42601 Character: 520 Here's a code snippet ... -- -- TOC entry 1685 (class 1262 OID 16453) -- Name: test_db; Type: DATABASE; Schema: -; Owner: postgres -- DROP DATABASE IF EXISTS test_db; CREATE DATABASE test_db WITH TEMPLATE = template0 ENCODING = 'UTF8'; ALTER DATABASE test_db OWNER TO postgres; \c test_db; -- query tool doesn't like this command :-( Rommel Edwards Software Developer, Barbados, Caribbean.