Re: Large number of rows in pg_type and slow gui (pgadmin) refresh

On Sun, 2013-01-06 at 11:27 -0600, Robert Klaus wrote:
> Get all schemas, except some of them.  One schema will have 90+% of the database objects.  
> 

You can already do that without having a custom pgAdmin.

> If we could eliminate that schema fewer rows would be returned by the underlying queries, allowing us to continue
usingpgAdmin.
 
> 
> I've only been working with this company (and postgresql) for 90 days so if there is a better way (other than
rewritingthe application that creates all those tables and views) please let me know how to proceed.
 
> 

Get into the properties of your database, select the Definition tab, add
your schema name in the "Schema restriction" textbox (make sure you put
single quotes around it), and click OK. Disconnect, reconnect... should
work.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com