Skip site navigation (1) Skip section navigation (2)

Re: Well, I am making some progress with createdb/dropdb

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Philippe Salama <karebacnyc(at)yahoo(dot)com>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Well, I am making some progress with createdb/dropdb
Date: 2006-12-22 22:58:17
Message-ID: 5D010393-98DB-4B2B-AF12-C4991E4C6396@decibel.org (view raw or flat)
Thread:
Lists: 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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

pgsql-admin by date

Next:From: saiDate: 2006-12-23 05:22:18
Subject: Pls Help Me
Previous:From: Jim NasbyDate: 2006-12-22 22:55:11
Subject: Re: pgexplorer cannot see data in tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group