Re: Fwd: How to encrypt a column

>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" ?

I'd check a previous critical point ... The encrypt() function output.
What is the range of characters in encrypt() output ?
Control, null or false escape characters, if not properly escaped, could be
misleading either sprintf or the query processor in pg.

Helder M. Vieira