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

Peter Eisentraut <peter_e@gmx.net> writes:
> 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?)

I think it was probably done to make it more visually distinct from the
adjacent identifiers, which would be lowercase more often than not.

Personally I'd suggest losing the word altogether; what's wrong with

Referenced by: "test2_y_fkey" test2 FOREIGN KEY (y) REFERENCES test1(a)

Or use TABLE:
 "test2_y_fkey" TABLE test2 FOREIGN KEY (y) REFERENCES test1(a)
        regards, tom lane