Re: PG vs MySQL

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