Re: Display of foreign keys in psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <stark(at)enterprisedb(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Display of foreign keys in psql
Date: 2009-06-10 22:21:05
Message-ID: 15373.1244672465@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <stark(at)enterprisedb(dot)com> writes:
> So perhaps something like:

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

+1

... although making it *really* copy-and-pastable would require a bit
more attention to detail than I bet it's gotten. (Schema qualification
and double-quoting-at-need being the likely trouble spots.) Still,
we can fix that later if we have the basic appearance being compatible
with that goal.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2009-06-10 22:33:32 Re: [HACKERS] Cursor with hold emits the same row more than once across commits in 8.3.7
Previous Message Tom Lane 2009-06-10 22:16:32 Re: Not quite a security hole in internal_in