The pg_indexes view might give you a starting point, also the pg_tables
view. You can see what they do, and take it from there.
>Hi again and sorry for the overhead,
>it seems I didn't express myself 100% clearly. I need a SELECT statement
>that will give me, for a given table (pg_class.relname='...'), the name of
>the column (pg_attribute.attname) that contains the primary key (if any),
>and the names of the columns that contain foreign keys.
>I can't seem to get there quite yet.
In response to
pgsql-novice by date
|Next:||From: Chris Smith||Date: 2001-06-07 23:01:08|
|Subject: Re: 2 novice questions|
|Previous:||From: Sykora, Dale||Date: 2001-06-07 22:39:17|
|Subject: 2 novice questions|