Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed modules (XML2, UUID) in Postgres.

In PG Admin III, all the functions contained in those modules display under the "Functions" tree.

The list is lengthy, and it slows down my work since I have to scroll around them quite a bit in my everyday projects.

Is there a way to hide (not display) the functions that are in add-on modules??

share|improve this question

migrated from Jan 28 '13 at 14:48

This question came from our site for professional and enthusiast programmers.

You can also create those functions in a different schema using create extension ... schema ... then those functions would not show up in the public schema. – a_horse_with_no_name Jan 28 '13 at 13:23
Thanks Horse.. that's what I did based on your suggestion. Worked great. It moved 23 functions out of the way, out of the main schema. I only had to change a few lines of code to add the schema name to the function calls. Also, it occurred to me that this is just good house keeping by separating core functions from functions I use daily for special projects. If you had this as an answer--I'd check the box. – Paulb Feb 3 '13 at 13:23

On the pgAdmin3 options dialogue, under "Browser -> Display", you'll find the various DB object types that you may display/hide in the browser.

share|improve this answer
Thanks. Tried that. It hides ALL the functions. I'm trying to hide the only the functions of the add-on modules. – Paulb Jan 29 '13 at 11:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .