On Wed, Nov 18, 2020 at 07:52:31AM -0700, David G. Johnston wrote:
> On Wed, Nov 18, 2020 at 7:44 AM Lior Dahan <liord@qmasters.co> wrote:
>
> Is there a way we can tell which tables are under this parent one? Perhaps
> we can dump them instead.
>
>
> The convention here is to inline or bottom-post.
>
> If you don't use declarative partitioning then the specifics of the
> partitioning are buried inside the custom trigger functions that you wrote. If
> you dump triggers, they will show in the pg_dump output, otherwise you will
> have to investigate using other means.
He is on PG 9.6.15, which doesn't support declarative partitioning, so
it must be trigger-based.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee