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