

Is all in next example good? See:

abil=> CREATE USER myname WITH PASSWORD BuBuBuBu;
CREATE USER                            ^^^^^^^^^^ 

abil=> select * from pg_shadow;
usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd     |valuntil
myname  |    5808|f          |f       |f       |f        |bubububu   |
                                                          ^^^^^^^^ 
(4 rows)


Why is in pg_shadow.passwd low case only?

							Zakkr


Thu, 7 Oct 1999 11:54:42 +0200 (CEST)
Zakkr <zakkr@zf.jcu.cz>
password in pg_shadow
> 
> 
> Is all in next example good? See:
> 
> abil=> CREATE USER myname WITH PASSWORD BuBuBuBu;
> CREATE USER                            ^^^^^^^^^^ 
> 
> abil=> select * from pg_shadow;
> usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd     |valuntil
> myname  |    5808|f          |f       |f       |f        |bubububu   |
>                                                           ^^^^^^^^ 
> (4 rows)
> 
> 
> Why is in pg_shadow.passwd low case only?

Try putting quotes aroud the password.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 7 Oct 1999 12:17:40 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] password in pg_shadow
> 
> 
> Is all in next example good? See:
> 
> abil=> CREATE USER myname WITH PASSWORD BuBuBuBu;
> CREATE USER                            ^^^^^^^^^^ 
> 
> abil=> select * from pg_shadow;
> usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd     |valuntil
> myname  |    5808|f          |f       |f       |f        |bubububu   |
>                                                           ^^^^^^^^ 
> (4 rows)
> 
> 
> Why is in pg_shadow.passwd low case only?

Sorry, try putting _double_ quotes aroud the password.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 7 Oct 1999 12:17:57 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] password in pg_shadow