Re: Post Install / Secure PostgreSQL

Alan Hodgson <ahodgson(at)simkin(dot)ca> writes:
> On September 15, 2010 11:10:45 am Carlos Mennens wrote:
>> Doesn't that show I'm connected to the 'postgres' database and there
>> is a table called 'pg_user' which holds all my PostgreSQL user info?
>> That doesn't make sense to me if the database is empty unless I am
>> missing something here. The only way I knew 'pg_user' was available
>> was because I ran the command '\dS'.

> system tables don't show up in normal views. I don't think they really belong
> to particular databases either, but someone might correct me on that.

There are a small number of "shared" catalogs, in particular the list of
users and the list of databases, that are visible in all databases.
Most of the catalogs are per-database, though, so that they can have
different contents in different databases.

regards, tom lane