'user' is a special word, it means 'current user name'. By example:
statsystem=> select user;
getpgusername
-------------
tolik
(1 row)
statsystem=>
'tolik' is my login name.
>>>>> "JZ" == John Ziniti <[EMAIL PROTECTED]> writes:
JZ> Sorry about that last one everyone. I misread the quetsion.
JZ> 'createdb user' seems not to work...
JZ> John
JZ> ************************************
JZ> Bernhard,
JZ> It seemed to work okay for me. What specifically was the problem?
JZ> bash-2.02$ createuser user
JZ> Enter user's postgres ID -> 7000
JZ> Is user "user" allowed to create databases (y/n) n
JZ> Is user "user" allowed to add users? (y/n) n
JZ> createuser: user was successfully added
JZ> don't forget to create a database for user
JZ> bash-2.02$
JZ> John
JZ> Bernhard Ertl wrote:
>> Sorry a stupid question, but might it be that 'user' isn't a valid name
>> for a database in Version 6.4? I used it in 6.2 and 6.3 and there it
>> worked fine ....
>>
>> Thanx Be
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
