Re: PG vs MySQL

> Just curious ... restricting \l itself isn't too difficult ... but how
> does MySQL restrict the ability to do something like:
>
> SELECT datname FROM pg_database;
>
> or does it not have an equivalent to that?

I'm not much of an expert in MySQL, but on my ISP 'show databases' only
shows MY databases.

I find MySQL's security tables arcane and confusing, but it may be that
I'm just more familiar with the way PG does it, because from the traffic
on the pgsql-general list it seems like questions about how to set up
the pg_hba.conf and pg_ident.conf are commonplace.

I also wonder how well the pg_hba.conf method will scale.  What happens
if there are hundreds of client databases or thousands of entries in
pg_hba.conf?
--
Mike Nolan