Re: Well, I am making some progress with createdb/dropdb - Mailing list pgsql-admin

From Jim Nasby
Subject Re: Well, I am making some progress with createdb/dropdb
Date
Msg-id 5D010393-98DB-4B2B-AF12-C4991E4C6396@decibel.org
Whole thread Raw
In response to Well, I am making some progress with createdb/dropdb  (Philippe Salama <karebacnyc@yahoo.com>)
List pgsql-admin
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)



pgsql-admin by date:

Previous
From: Jim Nasby
Date:
Subject: Re: reloading config files pg_ctl reload
Next
From: Jim Nasby
Date:
Subject: Re: pgexplorer cannot see data in tables