[GENERAL] [general] Encrypting/Decryption

2014-11-17 Thread VENKTESH GUTTEDAR
Hello, As i am new to postgresql and django. please help me to acheive the following. I have created a database with some tables and i want to encrypt the data in database tables, so please someone guide me how to do it.? i want to encrypt the data and also decrypt through django,

Re: [GENERAL] [general] Encrypting/Decryption

2014-11-17 Thread Naveed Shaikh
Hi Venktesh, Following is small test case: == leon=# create table demo(pw bytea); CREATE TABLE leon=# insert into demo(pw) values ( encrypt( 'data', 'key', 'aes') ); INSERT 0 1 leon=# select decrypt(pw, 'key', 'aes') FROM demo; decrypt \x64617461 (1 row)

Re: [GENERAL] [general] Encrypting/Decryption

2014-11-17 Thread Bill Moran
On Mon, 17 Nov 2014 16:53:43 +0530 VENKTESH GUTTEDAR venkteshgutte...@gmail.com wrote: Hello, As i am new to postgresql and django. please help me to acheive the following. I have created a database with some tables and i want to encrypt the data in database tables, so please

[GENERAL] Encrypting/Decryption

2014-11-14 Thread VENKTESH GUTTEDAR
Hello, As i am new to postgresql and django. please help me to acheive the following. I have created a database with some tables and i want to encrypt the data in database tables, so please someone guide me how to do it.? i want to encrypt the data and also decrypt through django,