"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> 'k, this is looking promising ... but I'm a bit confused on the TOAST
> tables ... I can't match on 'relname', since they aren't the same ... the
> old has, for instance:
> pg_toast_5773565
> while the new has:
> pg_toast_8709712
> is there some sort of 'linkage' in pg_class that I'm not seeing?
Yeah. A toast table's OID appears in the reltoastrelid field of its
owning table. So you match new and old pg_class entries by name,
take their reltoastrelid fields, look up those rows by OID, and their
relfilenode fields give the names of the TOAST files.
regards, tom lane