By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,853 Members | 2,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,853 IT Pros & Developers. It's quick & easy.

SHA function?

Atli
Expert 5K+
P: 5,058
Hi.

I've been looking for a function similar to MySQL's sha() function in Postgre and I can't seem to find anything.

The reason is that I have a system that is written for MySQL and I've been asked to make it compatible with Postgre.

Thanks.
Feb 25 '07 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
I haven't seen this in the standard Postgresql distribution, although Postgres internally uses md5 for password encoding.

Both, sha and md5 are provided with contrib/pgcrypto
(contrib is the set of optional extensions to the core Postgresql distribution.)

Many Postgres APIs (PHP, Java, etc) have their own implementation of sha and md5 and perhaps this could be another option to consider.
Feb 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.