Is there any relatively easy way to, uh, prevent your users from seeing
some/all of your pl/pgsql code in pgAdmin? A by schema solution
would be ideal.

Merlin

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Merlin Moncure wrote:
> Is there any relatively easy way to, uh, prevent your users from seeing
> some/all of your pl/pgsql code in pgAdmin? A by schema solution
> would be ideal.

I could think of an additional option for schema names that should be
treated as system schema (like the Slony-I and pgAgent schema), but
there's no solution to prevent reengineering that's not done on the
server side. And coding sophisticated algorithms in plpgsql is for
masochists only anyway ;-)

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster