Обсуждение: Create user

Поиск
Список
Период
Сортировка

Create user

От
"Ashish Karalkar"
Дата:
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?
 
Thanks In advance
Ashish...

Re: Create user

От
"A. Kretschmer"
Дата:
am  Fri, dem 29.06.2007, um 13:31:03 +0530 mailte Ashish Karalkar folgendes:
> 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.

Maybe you should use -q:

-q

       --quiet
       Do not display a response.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Create user

От
Dave Page
Дата:
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.

Re: Create user

От
"Albe Laurenz"
Дата:
Ashish Karalkar wrote:
> 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

Use -q instead of -e.

Yours,
Laurenz Albe