| From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
|---|---|
| To: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
| Cc: | Alex <alex(at)meerkatsoft(dot)com>, Frank Finner <postgresql(at)finner(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG vs MySQL |
| Date: | 2004-03-29 04:24:31 |
| Message-ID: | 20040329002058.E51637@ganymede.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-03-29 04:30:24 | Re: PG vs MySQL |
| Previous Message | G. Frank Liu | 2004-03-29 04:13:13 | psql error |