I think what he was looking for was more along the lines of a generic sql
function that hashes a string, and not to update the system tables.
I actually wrote a replacement for the mysql PASSWORD() function that is
actually compatible with the hashing that mysql uses. If you would like a
copy of this function just let me know so I can extract it out of the a
bunch of other functions.
On Fri, 21 Jul 2000, Roderick A. Anderson wrote:
> On Fri, 21 Jul 2000, Silesky Marketing Inc, Support wrote:
> > Hello,
> > I want to encrypt passwords with Postgresql the way mySQL does it with :
> > UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
> Check out the ALTER command.
> ALTER USER username
> [ WITH PASSWORD 'password' ]
> [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
> [ VALID UNTIL 'abstime' ]
> Roderick A. Anderson
> raanders(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
> Voice: 208.765.6149 212 S. 11th Street, Suite 5
> FAX: 208.664.5299 Coeur d'Alene, ID 83814
In response to
pgsql-sql by date
|Next:||From: Jan Wieck||Date: 2000-07-24 22:47:18|
|Subject: Re: TCL updates|
|Previous:||From: Jesus Aneiros||Date: 2000-07-24 22:25:03|
|Subject: RULES on PostgreSQL|
pgsql-general by date
|Next:||From: Paul Caskey||Date: 2000-07-24 22:37:51|
|Subject: 4 billion record limit?|
|Previous:||From: Jens P. Elsner||Date: 2000-07-24 22:33:41|
|Subject: Re: Migrating from Sybase|