Carlos Mennens <carlos.mennens@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
