Re:Why Pg_dump Is Amazing
by hobs on Saturday November 09, 2024 @01:38PM
(#42096057)
Just the problem with ordering of state in a database not matching the other database after you ran migrations.
Information schema being the authoritative schema for all the information about the meta state in most database systems (or at least the cross platform one) means you can write a query against these views and (if I am not mistaken) re-assemble state that's identical by ordering the application of the objects in the order they were created originally.
[ Parent
| on HN ]
Re:Why Pg_dump Is Amazing
by fooododododo on Saturday November 09, 2024 @05:09PM
(#42097214)
Is everything in pgdump in the information schema?