Re: [GENERAL] Confused About pg_* Tables

2011-10-14 Thread Tom Lane
Carlos Mennens 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 un

Re: [GENERAL] Confused About pg_* Tables

2011-10-14 Thread Julien Rouhaud
On Fri, Oct 14, 2011 at 6:57 PM, Julien Rouhaud wrote: > On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens > wrote: > >> 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' databa

Re: [GENERAL] Confused About pg_* Tables

2011-10-14 Thread Julien Rouhaud
On Fri, Oct 14, 2011 at 6:06 PM, Carlos Mennens wrote: > 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 da

[GENERAL] Confused About pg_* Tables

2011-10-14 Thread Carlos Mennens
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: Code: zoo=# SELECT * FROM pg_user; u