Thread: 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?
                        Zakkr

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

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