Skip site navigation (1) Skip section navigation (2)

Re: Have \d show child tables that inherit from the specified parent

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Have \d show child tables that inherit from the specified parent
Date: 2009-02-26 17:46:20
Message-ID: 603c8f070902260946m349c3e3drc41a3c1fd8e7378f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Feb 26, 2009 at 12:23 PM, Greg Sabino Mullane <greg(at)turnstep(dot)com> wrote:
>> This one is very basic, it just shows the child tables of a specific
>> table when you type \d <tablename> in psql :
>
> I'm not so jazzed about this, as I work on systems that have literally
> hundreds of child tables. When I do a \d on the master table, that's
> not what I want to see. Frankly, a good naming system goes a long
> way towards that, as children usually line up quick neatly in \d
> output. Can we make this only showup in \d+ perhaps? Or not do
> this at all? Or for \d, make it say "Use \d+ to view all children"?

Yeah, there is already an awful lot of output from regular old \d

Typically, I get indexes, check constraints, foreign key constraints,
and triggers.  It's not real easy to read.  It would be nice if there
were a way to suppress this output or only show the part you're
interested in at the moment, but it's hard to think of what syntax
might be reasonable.

...Robert

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-02-26 18:00:21
Subject: Re: xpath processing brain dead
Previous:From: Lawrence, RamonDate: 2009-02-26 17:34:57
Subject: Re: Proposed Patch to Improve Performance ofMulti-BatchHash Join for Skewed Data Sets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group