Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Has every postgreSQL database own users? - Mailing list pgsql-sql

From Maarten Boekhold
Subject Re: [SQL] Has every postgreSQL database own users?
Date
Msg-id 36BACB43.C72B6D1B@tibco.com
Whole thread Raw
In response to Re: [SQL] Has every postgreSQL database own users?  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
List pgsql-sql
Tree view 
>
> OK, but every database has pg_user table. Why this table is there?
>

They don't have their own copy. The pg_user (and pg_shadow) table are
shared between all databases (think of it as that every database has a
symlink to the 'global' pg_user table).

Maarten

--

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com

pgsql-sql by date:

Previous
From: Remigiusz Sokolowski
Date:
Subject: Re: [SQL] Has every postgreSQL database own users?
Next
From: Stanimir Stanev
Date:
Subject: date column