Re: Confused About pg_* Tables

Carlos Mennens <carlos.mennens@gmail.com> writes:
> I'm confused about how I'm able to access the following pg_* tables
> regardless of connected database. I thought these tables were hidden
> or stored in the 'postgres' database but I'm still able to access this
> data regardless of which database I'm connected to:

The underlying "pg_authid" catalog is a shared catalog that can be seen
from any database in the installation, just like pg_database.  pg_user
is a view on this catalog, and so not shared in itself, but nonetheless
you'll see the same contents from every database.

            regards, tom lane