: Re: [SQL] How to store a password encripted in a user defined table
MD5 is built-in to PostgreSQL. It is what PostgreSQL itself uses to
hash passwords. For example:
select md5('this is my password');
md5
--
210d53992dff432ec1b1a9698af9da
John,
That was what I was looking for for a long time.
Now I will change my teller password account to md5.
Could someone suggest me how to change all passwords (PLAIN) to md5 ?
My real best regards
Ezequias
2007/3/1, John DeSoi <[EMAIL PROTECTED]>:
MD5 is built-in to PostgreSQL. It is what
MD5 is built-in to PostgreSQL. It is what PostgreSQL itself uses to
hash passwords. For example:
select md5('this is my password');
md5
--
210d53992dff432ec1b1a9698af9da16
(1 row)
On Mar 1, 2007, at 6:06 AM, Eugenio Flores wrote:
Thanks Andrej
Andrej Ricnik-Bay wrote:
On 3/1/07, Eugenio Flores <[EMAIL PROTECTED]> wrote:
Hello, I wonder if somebody knows how to store passwords in a
column that is part of a user defined table.
Assuming that your passwords are application specific use
a sha1 or md5 algorithm (depending on how sensitive
lt;[EMAIL PROTECTED]>; PostgreSQL
Enviado: jueves, 1 de marzo, 2007 0:21:06
Asunto: Re: [SQL] How to store a password encripted in a user defined table
On 3/1/07, Eugenio Flores <[EMAIL PROTECTED]> wrote:
> Hello, I wonder if somebody knows how to store passwords in a
> column that is part
On 3/1/07, Eugenio Flores <[EMAIL PROTECTED]> wrote:
Hello, I wonder if somebody knows how to store passwords in a
column that is part of a user defined table.
Assuming that your passwords are application specific use
a sha1 or md5 algorithm (depending on how sensitive your data is)
and store th
Hello, I wonder if somebody knows how to store passwords in a column that is
part of a user defined table.
I've been searching and reading the documentation, but I can't find what I'm
looking for. I just get password subjects related to client's connections to
the database.
Thanks in advance
