Re: Display of foreign keys in psql

Greg Stark <stark(at)enterprisedb(dot)com> writes:
> On Wed, Jun 10, 2009 at 11:21 PM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Greg Stark <stark(at)enterprisedb(dot)com> writes:
>>> TABLE test2 CONSTRAINT test2_y_fkey FOREIGN KEY (y) REFERENCES test1(a);
>>
>> +1

> Even there the "TABLE" is kind of optional. It would stlil make sense as

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

I think that goes against our message style guidelines (46.3.9:
"When citing the name of an object, state what kind of object it is").
Not sure if brevity is worth a small chance of confusion.

regards, tom lane