David Scullion wrote:
> whenever i try to run the psql command it always tells me
> psql: FATAL 1: Database (dave) does not exist in the system catalogue
>
> then when i try createdb dave i get the same message
> except that it is user dave who doesn't exist in the system catalogue.
>
> Thanks in advance
>
> DavidScullion
>
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
Try:
createuser -a -d --username=postgres dave
To create user dave
then
createdb dbname
psql dbname
hth,
- Stuart