Thanks Tom and Adrian, The clarity is helpful - We'll run up a solution to specifically choose the elements.
cheers Ben On Sat, 15 Aug 2020 at 00:45, Tom Lane <t...@sss.pgh.pa.us> wrote: > Ben Madin <b...@ausvet.com.au> writes: > > " Is the index number ( the archive ID) assigned at the time of creation > > of the archive and not otherwise related to the item in the > > original database?" > > Yes, it's just assigned internally during pg_dump. I think the numbers > would hold still as long as you make no DDL changes in the database, but > as soon as you do, all bets are off. > > regards, tom lane > -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: b...@ausvet.com.au Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia
