| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Niels Jespersen <NJN(at)dst(dot)dk> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Tools showing table partitions as tables in listings of tables |
| Date: | 2020-12-09 12:37:47 |
| Message-ID: | 20201209123747.GA15672@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Dec 09, 2020 at 12:29:43PM +0000, Niels Jespersen wrote:
> A small irritation point is that some tools decide that partitions under a table are to be shown in a list of tables, sometimes
> drowning the main table in a sea of partitions.
While this doesn't answer your question directly, but when I had this
problem, I simply moved partitions to separate schema.
So, let's say I have table plans in schema public. All its partitions
are in "plans" schema.
Of course naming can be done differently, but the thing is that you can
do it, and it doesn't cause any issues with queries - as long as you use
main table and not directly partitions.
Best regards,
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wolfgang Walther | 2020-12-09 13:42:43 | Execution order of CTEs / set_config and current_setting in the same query |
| Previous Message | Niels Jespersen | 2020-12-09 12:29:43 | Tools showing table partitions as tables in listings of tables |