MD5 for PostgreSQL 7.3.4

[Tk421]

I'm looking for a function that returns a md5 encryption for postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had problems installing it on my Windows XP with Cygwin, so I need to found it for version 7.3

Anyone can help me?

Sorry about my english, i'm spanish

Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com

[Joe Conway]

Tk421 wrote:

I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3

See contrib/pgcrypto

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Joe Conway]

Tk421 wrote:

I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3

See contrib/pgcrypto

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Tk421]

I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption
Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com
----- Original Message -----
From: "Joe Conway" <ma**@joeconway.com>
To: "Tk421" <vr******@vodafone.es>
Cc: <pg***********@postgresql.org>
Sent: Wednesday, November 03, 2004 5:49 PM
Subject: Re: [GENERAL] MD5 for PostgreSQL 7.3.4

Tk421 wrote:

I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3

See contrib/pgcrypto

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Tk421]

I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption
Víctor Robador Capel

Análisis de Sistemas y Programación

www.creativosdolmen.com
----- Original Message -----
From: "Joe Conway" <ma**@joeconway.com>
To: "Tk421" <vr******@vodafone.es>
Cc: <pg***********@postgresql.org>
Sent: Wednesday, November 03, 2004 5:49 PM
Subject: Re: [GENERAL] MD5 for PostgreSQL 7.3.4

Tk421 wrote:

I'm looking for a function that returns a md5 encryption for
postgreSQL 7.3.4

I've found that this function exists on version 7.4, but I have had
problems installing it on my Windows XP with Cygwin, so I need to
found it for version 7.3

See contrib/pgcrypto

HTH,

Joe

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[Joe Conway]

Tk421 wrote:

I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption

Sure it does. See README.pgcrypto:

"SQL FUNCTIONS
=============

If any of arguments are NULL they return NULL.

digest(data::bytea, type::text)::bytea

Type is here the algorithm to use. E.g. 'md5', 'sha1', ...
Returns binary hash."

Joe

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Joe Conway]

Tk421 wrote:

I've been looking at contrib/pgcrypto but it hasn't any information
about md5 encryption

Sure it does. See README.pgcrypto:

"SQL FUNCTIONS
=============

If any of arguments are NULL they return NULL.

digest(data::bytea, type::text)::bytea

Type is here the algorithm to use. E.g. 'md5', 'sha1', ...
Returns binary hash."

Joe

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend