Re: Create user

Ashish Karalkar wrote:
> Hello All,
>
> I am  trying to create a user   and i dont understand why it is showing
> me any massage even after giving parameter -e to the command.
>
> command :
>
> C:\Program Files\PostgreSQL\8.2\bin>createuser ashish -S -d -R -l -P -E
> -e -U postgres
> Enter password for new role:
> Enter it again:
> Password:
>
> The following massage appers, I dont want to display this massage
>
> CREATE ROLE ashish ENCRYPTED PASSWORD
> 'md5e34280fa67e9a7d842044e45f2d5d325' NOSU
> PERUSER CREATEDB NOCREATEROLE INHERIT LOGIN;
> CREATE ROLE
>
> is there any option?

Remove the -e option. That turns on the SQL echoing.

Regards, Dave.