Re: Quick patch: Display sequence owner

On Tue, Dec 9, 2008 at 10:46 AM, Josh Williams <joshwilliams(at)ij(dot)net> wrote:
> On Tue, 2008-12-09 at 09:32 -0500, Tom Lane wrote:
>> 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
>
> That makes more sense, though isn't that a little repetitive when
> "default nextval(...)" is visible immediately above it?
>

actually, when a try your patch i have to look at the code to find
where you put such information... i tried \dt first...

> Doesn't guarantee the sequence is owned by the table of course, but I'd
> imagine to most people it'd just be noise. Could see it being shown in
> the verbose version, \d+ foo.bar.
>

that's exactly why we want the aditional info... the idea of putting
it on \d+ doesn't sounds too bad... to me at least...

> For the sequences themselves, it'd be nice to show somewhere, at least
> for tracking down stray sequences and identifying relationships.

in \ds maybe

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157