I think that's what digest does. It doesn't appear to install in 7.4 since 7.4 has the md5 function. I don't have a 7.3 box to test it on though... On Tue, 11 May 2004, Dias Bantekas wrote: > does any one know how to get an md5()-like hash function using pgcrypto > for postgresql 7.3 ? without upgrading to 7.4 > > Thanks for any input. > > Dias > > scott.marlowe wrote: > > On Sun, 11 Apr 2004, Jerry McBride wrote: > > > > > >>T. Relyea wrote: > >> > >> > >>>Mike Cox wrote: > >>> > >>> > >>>>Has anyone created something like that for Postgresql? It would be > >>>>really handy to encrypt credit card numbers and other information so > >>>>it stays secure. > >>>> > >>>>If no one has created anything such as this, I am going to code up > >>>>something quite soon, but if it already exists, there is no need for > >>>>me to reinvent the wheel, so speak up! It is a law in places such as > >>>>the EU that many types of data must be encrypted if the database is > >>>>compromised. > >>>> > >>>>I will put up my solution in a few days if one does not exist. But > >>>>before I do that, I want to give a quick tutorial on how to create a > >>>>file that will create tables, views and other such essentials. Most > >>>>people who use PostgreSQL just type in the commands in PostgreSQL, but > >>>>that is not as easily portable or backed up as what I'm about to show > >>>>you! > >>>> > >>>>1. open vi with a file. > >>>>2. Comments can be made as long as you add to slashes before the > >>>>line: > >>>>--this is a comment. > >>>>3. Next just type in the SQL commands you want! > >>>>4. after you are done, save the file. > >>>>5. then just do this to create the database you made in the file: > >>>>psql database_name < my_vi_file > >>>>6.That is it! > >>>> > >>>>Here is a very simple sample of a file: > >>>> > >>>>--This is a sample file. Use at your own risk. No Warranties > >>>>--Written by Mike Cox, author of the *nix "hm" command. > >>>> > >>>>create table first( > >>>>MYNUMBER INTEGER); > >>>> > >>>>create VIEW myview AS > >>>>select * from first; > >>>> > >>>>--Ok this is the end. As you can see it is very simple and portable. > >>>>--Try it out. Here's how: psql your_database < this_file > >>> > >>>MySQL has encryption and decryption functions built in, doesn't > >>>Postgresql? > >>> > >>>Todd > >> > >>Obviously not... that's why we don't use it at work.... > > > > > > let's see: > > > > su - > > cd /usr/local/src/postgresql-7.4.2 > > cd contrib/pgcrypto > > make > > make install > > > > Total time taken: <30 seconds. > > > > If that's a make or break deal for you on a database I'd hate to go car > > buying with you. > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 9: the planner will ignore your desire to choose an index scan if your > > joining column's datatypes do not match > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
