Hacker News new | ask | show | jobs
by erichanson 2382 days ago
To derefr's point, I'll also point to the "meta" PostgreSQL extension (part of the Aquameta project, which I maintain) whose purpose is to provide a more readable version of information_schema:

https://github.com/aquametalabs/meta http://blog.aquameta.com/intro-meta/

information_schema is pretty unruly, and pg_catalog is just crazy, in terms of readability, but if you just want to do some simple introspection, meta might be helpful.

That said, I see value in a nice Javascript object that is easy to traverse and can be retrieved all at once.

1 comments