Re: Issues with pg_dump command

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