On Thu, 19 Feb 2004, Rodrigo Sakai wrote:
> Hi, I'm responsable for the database here in the company, and I like
> to know if is there a way to compile my pl/pgsql functions, its not a
> performance problem, it is more a security problem, i don like to
> have somebody looking into my codes and see the company rules.
AFAIK there's not much you can do for obfuscation of pl functions right
now since someone will be able to see the src text in pg_proc. However,
are you allowing people that you don't want to see the code access to
write arbitrary sql to the database?
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
