Thread: Hide databases

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?

Best regards,

Uwe Dalluege

--------------------------------------------------------------------------
Hochschule fuer Angewandte Wissenschaften Hamburg
- University of Applied Sciences -
Fachbereich Geomatik
Rechenzentrum
Dipl.-Ing. Uwe Dalluege   :-)
Hebebrandstr. 1
22297 Hamburg
Tel.: +49 40 42875 - 5335 oder 5353 oder 5313
Fax:  +49 40 42875 - 5409
E-Mail: mailto:uwe.dalluege@rzcn.haw-hamburg.de
Url: http://www.haw-hamburg.de/geomatik/
--------------------------------------------------------------------------

Uwe Dalluege wrote:

>Hi, 
>
>is it possible to hide the databases where I am not the owner?
>  
>
No, not currently.

Regards,
Andreas

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

Andreas and Dave,

thank you very much for your intent
to implement a configurable SQL restriction.
I think, the "Deutsche Bildungswesen"
would be delighted! :-) (and so I)

We have about 300 students working with
PostgreSQL so you can imagine the little confusion
seeing 300 databases.

We tried to use ONE database with 300 schemata
(one student, one schema)
but this was the same problem :-(

Best regards,

Uwe


Andreas Pflug wrote:

> 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
> 
> 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?

Uwe Dalluege wrote:
> Andreas and Dave,
> 
> thank you very much for your intent
> to implement a configurable SQL restriction.
> I think, the "Deutsche Bildungswesen"
> would be delighted! :-) (and so I)
> 
> We have about 300 students working with
> PostgreSQL so you can imagine the little confusion
> seeing 300 databases.
> 
> We tried to use ONE database with 300 schemata
> (one student, one schema)
> but this was the same problem :-(

It's on the TODO list now; I'll try to implement it as soon as V1.4 is out.

Regards,
Andreas

<pre style="margin: 0em 0em 0em 80px;"><font face="Arial, Helvetica, sans-serif">Uwe Dalluege wrote:<br
/></font></pre><divstyle="margin-left: 80px;"><font face="Arial, Helvetica, sans-serif"><tt>Hi, </tt><tt>
</tt></font></div><prestyle="margin: 0em 0em 0em 80px;"><font face="Arial, Helvetica, sans-serif">is it possible to
hidethe databases where I am not the owner?<br /><br />In our university we have many postgresql user.<br />
 
Each user has his own database.<br />When I start pgAdmin all databases are displayed.<br />Is there a button to avoid
showingthese databases?<br /></font></pre><pre style="margin: 0em 0em 0em 40px;"><font face="Arial, Helvetica,
sans-serif">
Ok,<br /></font></pre><div style="margin-left: 40px;"><font face="Arial, Helvetica, sans-serif"><tt>Dave and me have
beendiscussing a little about this request, and we'll </tt><tt>probably implement a configurable SQL restriction for
thatin 1.5/1.6. </tt><tt>Your requirement seems typical for universities, let's declare this as </tt><tt>my
contributionto the Deutsches Bildungssystem! </tt></font><font face="Arial, Helvetica, sans-serif"><tt>Greetings to the
Geomatikum,where I spent quite some sleepy mornings in </tt><tt>lectures, I remember... </tt></font><font face="Arial,
Helvetica,sans-serif">Regards,</font><br /><font face="Arial, Helvetica, sans-serif">Andreas</font><br /></div><pre
style="margin:0em;"><font face="Arial, Helvetica, sans-serif"><br /></font></pre> Has there been any update on this?<br
/>

---

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?