Thursday, September 23, 2010

Postgresql Introspection.

Postgresql introspection is easy once you know where to look.

Despite working with Postgresql for the better part of a decade, I only recently discovered the Information Schema. It has all your database metadata laid out in nice, human readable views. No more wrestling with pg_catalog and other obscure system tables!

No comments:

Popular Posts