Or this is the bug in 9.1? Since it looks like there are 2 columns with the same info in 1 table/view.... Thank you. On Tue, Aug 22, 2017 at 12:08 AM, Igor Korot <ikorot01@xxxxxxxxx> wrote: > Hi, ALL, > draft=# SELECT * FROM information_schema.key_column_usage WHERE > table_schema = 'public' AND table_name = 'leaguescorehitter'; > constraint_catalog | constraint_schema | constraint_name > | table_catalog | table_schema | table_name | column_name | > ordinal_position | position_in_unique_constraint > --------------------+-------------------+--------------------------------+---------------+--------------+-------------------+-------------+------------------+------------------------------- > draft | public | leaguescorehitter_id_fkey > | draft | public | leaguescorehitter | id | > 1 | 1 > draft | public | leaguescorehitter_id_fkey1 > | draft | public | leaguescorehitter | id | > 1 | 1 > draft | public | leaguescorehitter_id_fkey1 > | draft | public | leaguescorehitter | playerid | > 2 | 2 > draft | public | > leaguescorehitter_scoreid_fkey | draft | public | > leaguescorehitter | scoreid | 1 | > 1 > (4 rows) > > There are 3 foreign keys in that table. > > Is there a way to get values of 0, 1, 1, and 2 for the ordinal position? > > Thank you. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
