On Sun, 28 Mar 2004, Mike Nolan wrote:
> > Huh? Each database under PostgreSQL is kept under a seperate directory on
> > the server ... always has been that way ..
>
> Perhaps, but it isn't obvious which directory has which database. I'm not
> not sure which system catalogs provide that information, something that
> wasn't obvious from the online docs, either.
SELECT oid FROM pg_database WHERE datname = '<database>';
or use the oid2name program that is in contrib ...
> The \l command should only list databases that the current user is
> authorized for, the \du command should only list users authorized for
> the current database (and perhaps only superusers should get even that
> much information), etc. Perhaps it is possible to set PG to do this,
> but that should probably be the default.
Now, those are good points, and I agree ... only pg-superuse should be
able to see all databases ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664