Re: Data Encryption in PostgreSQL, and a Tutorial. - Mailing list pgsql-general

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
>