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

2009-07-07 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Sunday 10 May 2009 03:05:48 dam...@dalibo.info wrote: Here's a second version. Main changes are : * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the full list Committed. I looked at this patch. I'm a

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

2009-07-07 Thread Peter Eisentraut
On Tuesday 07 July 2009 19:35:54 Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Sunday 10 May 2009 03:05:48 dam...@dalibo.info wrote: Here's a second version. Main changes are : * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the

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

2009-07-07 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Tuesday 07 July 2009 19:35:54 Tom Lane wrote: I looked at this patch. I'm a bit disturbed by the ORDER BY c.oid::pg_catalog.regclass business. I doubt that does what the author thinks, and I'm not sure what we really want anyway. If we want the

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

2009-07-03 Thread Peter Eisentraut
On Sunday 10 May 2009 03:05:48 dam...@dalibo.info wrote: Here's a second version. Main changes are : * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the full list Committed. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

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

2009-05-10 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the full list This table has 4 child table(s). Use \d+ to display them. Would be nice if you could get rid of that ugly '(s)' part. Child tables:

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

2009-05-10 Thread Euler Taveira de Oliveira
Greg Sabino Mullane escreveu: * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the full list This table has 4 child table(s). Use \d+ to display them. Would be nice if you could get rid of that ugly '(s)' part. What about Child Tables: 4? It is

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

2009-05-09 Thread dam...@dalibo.info
Hi, Here's a second version. Main changes are : * Child tables are sorted by name * \d only shows the number of child tables * \d+ shows the full list Which gives : postgres=# \d mother Table public.mother Column | Type | Modifiers

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

2009-03-23 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 That being said i recognize that people who have dozens of child tables might get annoyed by this patch. Dozens is on the low end: there are often a dozen dozen or more. Here's 3 ideas that could make things better : 1- When using \d ,

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

2009-03-20 Thread damien clochard
Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 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. hi

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

2009-02-26 Thread David Fetter
On Wed, Feb 25, 2009 at 07:30:30PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: Should the patch (and the feature) use WITH RECURSIVE in order to get the entire tree? See the note at the top of that file that all queries are expected to work with server versions back to

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

2009-02-26 Thread Tom Lane
David Fetter da...@fetter.org writes: On Wed, Feb 25, 2009 at 07:30:30PM -0500, Tom Lane wrote: See the note at the top of that file that all queries are expected to work with server versions back to 7.4. Would it be OK to have a different code path for pre-8.4 databases? I don't really see

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

2009-02-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 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

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

2009-02-26 Thread Robert Haas
On Thu, Feb 26, 2009 at 12:23 PM, Greg Sabino Mullane g...@turnstep.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

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

2009-02-25 Thread David Fetter
On Thu, Feb 26, 2009 at 12:25:08AM +0100, damien clochard wrote: Hello, Last week, i took some time to check if i was still able to write some basic C code. So i looked into the TODO list and picked some trivial items. This one is very basic, it just shows the child tables of a specific

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

2009-02-25 Thread Tom Lane
David Fetter da...@fetter.org writes: Should the patch (and the feature) use WITH RECURSIVE in order to get the entire tree? See the note at the top of that file that all queries are expected to work with server versions back to 7.4. regards, tom lane -- Sent via