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
