Re: Hide databases
| От | Dave Page |
|---|---|
| Тема | Re: Hide databases |
| Дата | |
| Msg-id | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D91B@ratbert.vale-housing.co.uk обсуждение исходный текст |
| Ответ на | Re: Hide databases ("Ryan Proud" <ryan@binarymelon.com>) |
| Список | pgadmin-support |
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Ryan Proud
Sent: 26 October 2006 13:40
To: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Hide databasesUwe Dalluege wrote:Hi,is it possible to hide the databases where I am not the owner?
In our university we have many postgresql user.
Each user has his own database.
When I start pgAdmin all databases are displayed.
Is there a button to avoid showing these databases?Ok,Dave and me have been discussing a little about this request, and we'll probably implement a configurable SQL restriction for that in 1.5/1.6. Your requirement seems typical for universities, let's declare this as my contribution to the Deutsches Bildungssystem! Greetings to the Geomatikum, where I spent quite some sleepy mornings in lectures, I remember... Regards,
AndreasHas there been any update on this?
Yes - you can hide databases and schemas in 1.6 (currently in beta). You reminded me so I've added the following note to the docs (the server properties page to be exact):
The DB restriction field allows you to enter an SQL restriction that will be used against the pg_database table to limit the databases that you see. For example, you might enter: datname IN ('live_db', 'test_db') so that only live_db and test_db are shown in the pgAdmin browser. Note that you can also limit the schemas shown in the database from the Database properties dialogue by entering a restriction against pg_namespace.
Regards, Dave.
В списке pgadmin-support по дате отправления: