On Tue, Dec 9, 2008 at 10:46 AM, Josh Williams <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to