Обсуждение: Where are all the users?

Hi @ all,

I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of
my DB. But I saw that pg_user is a view. Where are the information I
need?

Thank for your help

Kay-Uwe Genz

Kay-Uwe Genz <kug1977@web.de> wrote:
>
> Hi @ all,
>
> I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of
> my DB. But I saw that pg_user is a view. Where are the information I
> need?

Maybe you could \d the view and find out?  *But* you have to have
the proper permissions to actually see/reference the data.

Jim