Re: Display of foreign keys in psql

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Display of foreign keys in psql
Дата
Msg-id 4136ffa0906101533m10a1ddffh8d27aa4ad7289a51@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Display of foreign keys in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Display of foreign keys in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Display of foreign keys in psql