Re: Quick patch: Display sequence owner

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Josh Williams wrote:
>> The patch adds a query against pg_depend, then fakes an extra column
>> "owned_by" in the output:

> Please send a context diff (diff -c)

Don't bother --- it's a really bad idea as designed anyway.  owned_by
is not a column of a sequence relation and pretending that it is one
will just cause confusion.

I think the place that such information could most naturally be squeezed
into psql's \d commands would be to add another type of footer
information to \dt, eg
    Table "foo.bar"...Indexes:    "bari" ...Owned sequences:    "baz" owned by col1    ...

If you really want to attach the information to the \d output for the
sequence instead of the table, consider a similar footer-style display
instead of making it look like something it's not.
        regards, tom lane