Re: Display of foreign keys in psql

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Display of foreign keys in psql
Дата
Msg-id 200906102158.n5ALwiJ05182@momjian.us
обсуждение исходный текст
Ответ на Display of foreign keys in psql  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Display of foreign keys in psql  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Display of foreign keys in psql  (Greg Stark <stark@enterprisedb.com>)
Список pgsql-hackers
Peter Eisentraut wrote:
> I'm having trouble coming up with a sensible translation for the last line of 
> this:
> 
> peter=# \d test*
>      Table "public.test1"
>  Column |  Type   | Modifiers
> --------+---------+-----------
>  a      | integer | not null
> Indexes:
>     "test1_pkey" PRIMARY KEY, btree (a)
> Referenced by:
>   "test2_y_fkey" IN test2 FOREIGN KEY (y) REFERENCES test1(a)
> 
> Is there a magic reason why the IN is capitalized?  (Maybe "from" would be 
> better anyway?)

Probably not.  They were used to capitalizing "IN" for a subquery and it
carried over;   should be lowercase.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Display of foreign keys in psql
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Display of foreign keys in psql