3 ms·
The information schema is part of the SQL standard so the queries should be the same in all the databases that support that (which is quite a few). Here's the d
by mvc 7y ago
The information schema is part of the SQL standard so the queries should be the same in all the databases that support that (which is quite a few). Here's the doc links for MySQL and PostgreSQL
https://dev.mysql.com/doc/refman/8.0/en/information-schema.html https://dev.mysql.com/doc/refman/8.0/en/information-schema.h...
https://www.postgresql.org/docs/12/information-schema.html https://www.postgresql.org/docs/12/information-schema.html
As it happens, I did a talk about this at re:Clojure this week. Videos aren't up yet but they will appear here when they are available
https://www.youtube.com/channel/UCbZW8yCqEncYciie8_1yy7w/featured https://www.youtube.com/channel/UCbZW8yCqEncYciie8_1yy7w/fea...