On 7 July 2017 at 08:54, Michael Banck <michael.ba...@credativ.de> wrote: > On Fri, Jul 07, 2017 at 07:40:55PM +1200, Mark Kirkwood wrote: >> On 07/07/17 13:29, Amit Langote wrote: >> >Someone complained about this awhile back [1]. And then it came up again >> >[2], where Noah appeared to take a stance that partitions should be >> >visible in views / output of commands that list "tables". >> > >> >Although I too tend to prefer not filling up the \d output space by >> >listing partitions (pg_class.relispartition = true relations), there >> >wasn't perhaps enough push for creating a patch for that. If some >> >committer is willing to consider such a patch, I can make one. >> >> Yeah, me too (clearly). However if the consensus is that all these partition >> tables *must* be shown in \d output, then I'd be happy if they were >> identified as such rather than just 'table' (e.g 'partition table'). > > +1.
+1 to remove partitions from \d display With 1000 partitions that would just be annoying -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers