template1=# \h CREATE DATABASE
Command: CREATE DATABASE
Description: create a new database
Syntax:
CREATE DATABASE name
[ [ WITH ] [ OWNER [=] dbowner ]
[ TEMPLATE [=] template ]
[ ENCODING [=] encoding ]
[ TABLESPACE [=] tablespace ] ]
-- Andrei Reinus
-- "#define QUESTION ((bb) || !(bb)) - Shakespeare."
Stephen Choularton wrote:
> Hi
>
>
>
> Really lost. I have managed to get the prompt working but when I try
> to make a db nothing happens. (I am on windows XP)
>
>
>
> template1-# \l
>
> List of databases
>
> Name | Owner | Encoding
>
> -----------+----------+-----------
>
> template0 | postgres | SQL_ASCII
>
> template1 | postgres | SQL_ASCII
>
> (2 rows)
>
>
>
> template1-# makedb mydb
>
> template1-# \l
>
> List of databases
>
> Name | Owner | Encoding
>
> -----------+----------+-----------
>
> template0 | postgres | SQL_ASCII
>
> template1 | postgres | SQL_ASCII
>
> (2 rows)
>
>
>
> Can anyone tell me what I am doing wrong?
>
>
>
> Stephen
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005
>