Re: I have no idea why pg_dump isn't dumping all of my data

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Friday, May 21st, 2021 at 12:46, Ian Lawrence Barwick <barwick(at)gmail(dot)com> wrote:

> 2021年5月21日(金) 20:42 Vijaykumar Jain vijaykumarjain(dot)github(at)gmail(dot)com:
>

> > PostgreSQL: Documentation: 13: 37.17. Packaging Related Objects into an Extension
> >

> > so it works as expected.
> >

> > someone would have to point to the reference wrt modification of data in objects created via extension.
>

> If you want to be able to dump data inserted into extension tables,
>

> the tables will need
>

> to be marked using "pg_extension_config_dump()" in the extension script, see:
>

> https://www.postgresql.org/docs/current/extend-extensions.html#EXTEND-EXTENSIONS-CONFIG-TABLES
>

> and also:
>

> https://pgpedia.info/p/pg_extension_config_dump.html
>

> Regards
>

> Ian Barwick
>

> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>

> EnterpriseDB: https://www.enterprisedb.com

I finally had a chance to test this out today and it seems to be fixed now. Thank you for the help. I would never have found that on my own.

Simon.