Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Jan 28 '13 at 14:48

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

3  
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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.