[GENERAL] What is the proper query
От | Igor Korot |
---|---|
Тема | [GENERAL] What is the proper query |
Дата | |
Msg-id | CA+FnnTzcoQUW0p-NSgHev9YUYusdH5ZeFq-W4sF=EbNLPV-rzQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [GENERAL] What is the proper query
Re: [GENERAL] What is the proper query |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: