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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
