|
Home > Archive > Pgadmin > October 2006 > Re: Hide databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Hide databases
|
|
| Ryan Proud 2006-10-26, 7:27 pm |
| Uwe 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,
Andreas
Has there been any update on this?
| |
| Dave Page 2006-10-26, 7:27 pm |
|
____________________
____________
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 databases
Uwe 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,
Andreas
Has 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
<file:///C:/ Documents%20and%20Se
ttings/dpage/My%20Documents/SVN/pgadmin3
/docs/en_US/pg/catalog-pg-database.html> 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
<file:///C:/ Documents%20and%20Se
ttings/dpage/My%20Documents/SVN/pgadmin3
/docs/en_US/pg/catalog-pg-namespace.html> .
Regards, Dave.
|
|
|
|
|