Re: Data Encryption in PostgreSQL, and a Tutorial. - Mailing list pgsql-general
From | Dias Bantekas |
---|---|
Subject | Re: Data Encryption in PostgreSQL, and a Tutorial. |
Date | |
Msg-id | 40A0E9E7.1030600@aia.gr Whole thread Raw |
In response to | Re: Data Encryption in PostgreSQL, and a Tutorial. ("scott.marlowe" <scott.marlowe@ihs.com>) |
Responses |
Re: Data Encryption in PostgreSQL, and a Tutorial.
("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Data Encryption in PostgreSQL, and a Tutorial. (Michal Hlavac <hlavki@medium13.sk>) |
List | pgsql-general |
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 >
pgsql-general by date: