4 ms·
As the author of a postgres-specific schema inspection tool, I found I very quickly ran into limitations of information_schema. Many of the critical details are
by djrobstep 7y ago
As the author of a postgres-specific schema inspection tool, I found I very quickly ran into limitations of information_schema. Many of the critical details are simply not there.
- hobs 7y agoAs a DBA every full fledged system I have worked with veers off of information schema almost immediately, and you are going to be forced to implement some special set of queries if you want an accurate version of any real db schema. This will also likely reflect the current version of the database engine you are working with, there's no consistent approach to know everything for all databases for all versions.