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