Again: How do I select primary/foreign keys?
От
ffrt
Тема
Again: How do I select primary/foreign keys?
Дата
Msg-id
Pine.LNX.4.33.0106071714360.21084-100000@ace
Список
Дерево обсуждения
Again: How do I select primary/foreign keys? ffrt <ffrt@ace.ulyssis.org>
Re: Again: How do I select primary/foreign keys? Chris Smith <csmith@squiz.net>
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. Wim -- ffrt (pgp public key on simple request) Key fingerprint: FE F8 D4 63 A5 93 98 80 AC 7F 95 C1 85 6E 39 53
В списке pgsql-novice по дате отправления