Fwd: How to encrypt a column - Mailing list pgsql-sql

Hi,

 

I'm interested in encrypting an column in table.  Are there any example using "C" to create the encrypted column, inserting and retreiving data  to/from it?

 

the table is:

CREATE TABLE mytable ( 
     id SERIAL PRIMARY KEY, 
     crypted_content BYTEA );

I'm getting (null) in the field with the following sql statement:

 

strcpy(data, "data to be encrypted");

sprintf(query_buff, "insert into mytable values('%s', '%s')", key, encrypt(data, 'foo', 'bar'));

PQexec(conn, query_string);

 

Another question is can the encrypted column be of type "text" ?

 

Thank you