Re: [HACKERS] password in pg_shadow - Mailing list pgsql-hackers

> 
> 
> 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,
Pennsylvania19026