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?
Thank for your help
Kay-Uwe Genz
---(end of broadcast)
From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]>
>
> 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
gn
"gnari" <[EMAIL PROTECTED]> schrieb am 01.08.04 19:11:26:From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]>> > 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 in
"Kay-Uwe Genz" <[EMAIL PROTECTED]> :
> "gnari" <[EMAIL PROTECTED]> schrieb am 01.08.04 19:11:26:
>
> From: "Kay-Uwe.Genz" <[EMAIL PROTECTED]>
> >
> > 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
On Tue, 2004-08-03 at 05:57, Kay-Uwe Genz wrote:
>
> 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 ult
Kay-Uwe Genz <[EMAIL PROTECTED]> 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 permissi