Re: Post Install / Secure PostgreSQL - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Post Install / Secure PostgreSQL
Date
Msg-id 201009151115.32800.ahodgson@simkin.ca
Whole thread Raw
In response to Re: Post Install / Secure PostgreSQL  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Post Install / Secure PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Re: Post Install / Secure PostgreSQL
Next
From: John R Pierce
Date:
Subject: Re: Post Install / Secure PostgreSQL