Re: [HACKERS] password in pg_shadow

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Zakkr <zakkr(at)zf(dot)jcu(dot)cz>
Cc: pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] password in pg_shadow
Date: 1999-10-07 16:17:40
Message-ID: 199910071617.MAA01318@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Try putting quotes aroud the password.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-10-07 16:17:57 Re: [HACKERS] password in pg_shadow
Previous Message Thomas Lockhart 1999-10-07 15:30:08 Re: psql and comments