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 readab

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 https://github.com/aquametalabs/meta http://blog.aquameta.com/intro-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.