Re: Data Encryption in PostgreSQL, and a Tutorial.

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....

--

******************************************************************************
Registered Linux User Number 185956
http://groups.google.com/groups?hl=en&safe=off&group=linux
Join me in chat at #linux-users on irc.freenode.net
This email account no longers accepts attachments or messages containing
html.
12:26pm up 35 days, 13:39, 2 users, load average: 2.51, 2.56, 2.58