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

From Greg Stark
Subject Re: Display of foreign keys in psql
Date
Msg-id 4136ffa0906101533m10a1ddffh8d27aa4ad7289a51@mail.gmail.com
Whole thread Raw
In response to Re: Display of foreign keys in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Display of foreign keys in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jun 10, 2009 at 11:21 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Greg Stark <stark@enterprisedb.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.

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)

and even like that it looks like it's the widest line in the printout

--
Gregory Stark
http://mit.edu/~gsstark/resume.pdf


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7
Next
From: Tom Lane
Date:
Subject: Re: Display of foreign keys in psql