| From: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
|---|---|
| To: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
| Cc: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: I have no idea why pg_dump isn't dumping all of my data |
| Date: | 2021-05-21 11:46:52 |
| Message-ID: | CAB8KJ=jJG+R5xQpf7PKAcsKexvv9s-kC_SzfST_TTCA89H30XA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2021-05-21 15:17:52 | Re: Question about integer out of range in function |
| Previous Message | Vijaykumar Jain | 2021-05-21 11:42:11 | Re: I have no idea why pg_dump isn't dumping all of my data |