Fwd: How to encrypt a column

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

---------------------------------
Start your day with Yahoo! - make it your home page