Thread: Re: Where are all the users?

p {margin: 0px}p {margin: 0px}"gnari" <gnari@simnet.is> schrieb am 01.08.04 19:11:26:From: "Kay-Uwe.Genz"
<kay-uwe.genz@web.de>>> Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:> > > 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?template1=# d pg_usergnariBut pg_user is a view and cant referenced. So
Itry to use pg_shadow, but PG say that this is an System table and I cant use it.Kay-Uwe Genz<td
style="font-family:verdana;font! 
 -size:12px; line-height:17px;">Verschicken Sie romantische, coole und witzige Bilder per SMS!  Jetzt neu bei
WEB.DEFreeMail: http://freemail.web.de/?mc=021193   

"Kay-Uwe Genz" <kay-uwe.genz@web.de> :


> "gnari" <gnari@simnet.is> schrieb am 01.08.04 19:11:26:
>
> From: "Kay-Uwe.Genz" <kay-uwe.genz@web.de>
> >
> > Am 01.08.2004 um 10:44 schrieb Kay-Uwe Genz:
> >
> > > 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?
>
> template1=# d pg_user
>
> gnari
>
> But pg_user is a view and cant referenced. So I try to use pg_shadow,
> but PG say that this is an System table and I cant use it.

so you real question is probably:
    how can i modify the structure of system tables ?

you do not say what your ultimate purpose is, so I cannot see if the
FOREIGN KEY reference is necessary, but if you really need it, it possibly
might be done by starting postgres in single-user mode, with correct
options.

my guess is that this should only be done by someone who knows what he is
doing.

gnari