Re: Where is 'createdb'?

I type 'find createdb' and I get an error find: 'createdb' no such file or
directory.

From: Magnus Hagander [mailto:magnus(at)hagander(dot)net]
Sent: Thursday, November 01, 2012 10:38 AM
To: Kevin Burton
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Where is 'createdb'?

On Thu, Nov 1, 2012 at 4:32 PM, Kevin Burton <rkevinburton(at)charter(dot)net>
wrote:

This is probably a question for the authors of a book I have been reading
but it may be faster to get an answer here.

I was trying to follow along in a book 'Seven Databases in Seven Weeks' and
chapter 2 deals with PostgreSQL. One of the first things it does is issue a
command 'createdb book'. The text before this command says, "Once you have
Postgres installed, create a schema called book using the following command:
$ createdb book' But when I tried to issue this command (at a Linux command
prompt) I get 'createdb command not found'. Are the authors out of date?
What is the current command?

The authors are incorrect, in that this doesn't actually create a schema. It
creates a database. but they are not out of tdate, just incorrect - it has
never created a schema.

That said, the createdb command ships with postgresql still and should be
avaiable. Exactly where it is depends on how you installed PostgreSQL, and
which distribution of Linux you are on. You can probably find it with
"find", or by looking at the contents of whichever package you used to
install it.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/