It allows me to easily backup the schema (regardless of the number of
tables). I can move several tables into that schema, and back up the
schema.
Really just to help me organize my own processes.
Joe.
On Fri, May 30, 2025 at 7:45 AM Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
wrote:
> > On May 30, 2025, at 7:39 AM, Joe Tailleur <joe(dot)tailleur(at)gmail(dot)com>
> wrote:
> >
> > Using table partitioning works well for me. I detach and move the
> partition to an archive schema; which I can then backup and restore into a
> separate database, and once that is complete, remove the table from the
> archive schema on the live database.
>
> What's the purpose of the archive schema?