pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Well, I am making some progress with createdb/dropdb
2+ messages / 2 participants
[nested] [flat]

* Well, I am making some progress with createdb/dropdb
@ 2006-12-09 23:19  Philippe Salama <karebacnyc@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Philippe Salama @ 2006-12-09 23:19 UTC (permalink / raw)
  To: pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Well, I am making some progress with createdb/dropdb
@ 2006-12-22 22:58  Jim Nasby <decibel@decibel.org>
  parent: Philippe Salama <karebacnyc@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jim Nasby @ 2006-12-22 22:58 UTC (permalink / raw)
  To: Philippe Salama <karebacnyc@yahoo.com>; +Cc: 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)





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-12-22 22:58 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-12-09 23:19 Well, I am making some progress with createdb/dropdb Philippe Salama <karebacnyc@yahoo.com>
2006-12-22 22:58 ` Jim Nasby <decibel@decibel.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox