mgould wrote: > We are currently migrating from Sybase's ASA 9/10 to PostGres > 8.2.4. One of the features that is really nice in ASA is the > ability to add the attribute hidden to a Create procedure, > Create function and Create trigger. Essentially what this > does is encrypt the code so that if anyone or any utility > gets into the database they cannot see any of the actual > code. This is a great feature for protecting intellectual > processing techniques. I don't know if there is anyway to do > this in PostGres. Before the hidden feature was added, we > had a competitor steal some of our stored procedure > processing code. Is there anyway to protect this from > happening in PostGres? Not with PL/pgSQL. That's probably not what you want, but you can write stored procedures in C and ship the shared library. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly