Re: Display of foreign keys in psql - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Display of foreign keys in psql
Date
Msg-id 200906102158.n5ALwiJ05182@momjian.us
Whole thread Raw
In response to Display of foreign keys in psql  (Peter Eisentraut <peter_e@gmx.net>)
Responses 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>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Display of foreign keys in psql
Next
From: "Kevin Grittner"
Date:
Subject: Re: Display of foreign keys in psql