Thread: how to encrypt trigger function

Just curious whether there is such feature in postgres that allows you to encrypt the trigger function. I don't want to expose the trigger function content to the curious mind. Any suggestion will be much appreciated.

/Weng

On Apr 5, 2006, at 5:22 PM, Winson Yung wrote:

> Just curious whether there is such feature in postgres that allows
> you to encrypt the trigger function. I don't want to expose the
> trigger function content to the curious mind. Any suggestion will
> be much appreciated.

Not for SQL or pl/pgsql functions. You could write it in C and
compile it.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

On Apr 11, 2006, at 1:31 AM, Winson Yung wrote:

> I am not sure how to do it in C, could you give an example?

The PostgreSQL documentation has an example here:

http://www.postgresql.org/docs/8.1/interactive/trigger-example.html


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

I am not sure how to do it in C, could you give an example?
thanks