From karebacnyc@yahoo.com Sat Dec 9 23:19:06 2006 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7F1689F9F46 for ; Sat, 9 Dec 2006 19:19:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 73224-09 for ; Sat, 9 Dec 2006 19:18:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web90507.mail.mud.yahoo.com (web90507.mail.mud.yahoo.com [216.252.100.174]) by postgresql.org (Postfix) with SMTP id 390319F9C35 for ; Sat, 9 Dec 2006 19:19:02 -0400 (AST) Received: (qmail 13557 invoked by uid 60001); 9 Dec 2006 23:19:00 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Fn1RR96NlLDTtPKEj8ThMjuBRF1fjzQsjEdDGPmsow49DHorvCaUJ6YGF3vKldAuKF/jJF7b3Wo6eGPxTzyl7voZKy+3s80TasNI6Z30VjNwGyHjn34k7BOdoY8SkNiVC0Ub3R9PI7t2YOmRHtx5edJbCrhD1Gh7Khjt5SFlUWQ=; X-YMail-OSG: MXBvCxQVM1kelF83nUmc9HwOkXCCScmh70HzQuTVLA8E5DqGH1SMlB3_RGLj7AcP9A-- Received: from [70.19.76.226] by web90507.mail.mud.yahoo.com via HTTP; Sat, 09 Dec 2006 15:19:00 PST Date: Sat, 9 Dec 2006 15:19:00 -0800 (PST) From: Philippe Salama Subject: Well, I am making some progress with createdb/dropdb To: PostgreSQL Admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1156557520-1165706340=:8260" Content-Transfer-Encoding: 8bit Message-ID: <183140.8260.qm@web90507.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.971 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200612/125 X-Sequence-Number: 23917 --0-1156557520-1165706340=:8260 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit The textbook wanted me to create-db -U neil bpsimple, but I accidentally created it as postgres. I want to follow directions so future exercises will work ok. It has taken me a while to figure out that there are , in bin, programs such as createdb.exe which look for parameters on command line such as -U neil bpsimple So, I had to figure out how to dropdb.exe -U postgres bpsimple And then recreate it as createdb.exe -U neil bpsimple It is confusing for me to keep straight which things are .exe in bin, and which are command lines in psql. --------------------------------- Have a burning question? Go to Yahoo! Answers and get answers from real people who know. --0-1156557520-1165706340=:8260 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit The textbook wanted me to create-db -U neil bpsimple, but I accidentally created it as postgres.  I want to follow directions so future exercises will work ok.

It has taken me a  while to figure out that there are , in bin, programs such as createdb.exe which look for parameters on command line such as
-U neil bpsimple

So, I had to figure out how to dropdb.exe -U postgres bpsimple

And then recreate it as createdb.exe -U neil bpsimple

It is confusing for me to keep straight which things are .exe in bin, and which are command lines in psql.



Have a burning question? Go to Yahoo! Answers and get answers from real people who know. --0-1156557520-1165706340=:8260-- From decibel@decibel.org Sat Dec 23 06:48:23 2006 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B6E489F9ED7 for ; Sat, 23 Dec 2006 02:48:23 -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 47632-07 for ; Sat, 23 Dec 2006 02:48:13 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id E81D79FA1DA for ; Sat, 23 Dec 2006 02:48:14 -0400 (AST) Received: from [192.168.42.125] (natpool.bovine.net [67.100.216.14]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id BC7515643F; Sat, 23 Dec 2006 06:48:13 +0000 (UTC) In-Reply-To: <183140.8260.qm@web90507.mail.mud.yahoo.com> References: <183140.8260.qm@web90507.mail.mud.yahoo.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <5D010393-98DB-4B2B-AF12-C4991E4C6396@decibel.org> Cc: PostgreSQL Admin Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: Well, I am making some progress with createdb/dropdb Date: Fri, 22 Dec 2006 17:58:17 -0500 To: Philippe Salama X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/300 X-Sequence-Number: 24092 On Dec 9, 2006, at 6:19 PM, Philippe Salama wrote: > The textbook wanted me to create-db -U neil bpsimple, but I > accidentally created it as postgres. I want to follow directions > so future exercises will work ok. > > It has taken me a while to figure out that there are , in bin, > programs such as createdb.exe which look for parameters on command > line such as > -U neil bpsimple > > So, I had to figure out how to dropdb.exe -U postgres bpsimple > > And then recreate it as createdb.exe -U neil bpsimple > > It is confusing for me to keep straight which things are .exe in > bin, and which are command lines in psql. I think the docs make it pretty obvious which is which, but as a rule of thumb, people tend to capitalize SQL commands (ie: CREATE DATABASE), but not the command-line commands. When in doubt, there's an entire section of the docs that is a reference to all commands. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)