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--