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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
