[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 по дате отправления:

Предыдущее
От: Fadhel J Muhammad
Дата:
Сообщение: [GENERAL] Postgresql_for_odoo
Следующее
От: Dylan Luong
Дата:
Сообщение: Re: [GENERAL] pg_rewind - restore new slave failed to startup duringrecovery