Re: Display of foreign keys in psql

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. +