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 <[email protected]> wrote: > Ben Madin <[email protected]> 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: [email protected] Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia
