Generic database dictionary access
mfuhr at fuhr.org
Mon Jun 14 03:52:07 CEST 2004
"Edward Diener" <eldiener at earthlink.net> writes:
> Has there been any movement in the 5 year time span since the 2.0 API
> was published to add richer generic functionality for relational
> databases as regards data dictionary access ? I fully realize that each
> major RDBMS has its own methods for programatically querying its data
> dictionary, and I suspect that there is no common SQL specification for
> doing so, but I would think that richer functionality along these lines
> might be welcome to Python database programmers other than myself.
SQL defines INFORMATION_SCHEMA as a standard way to query metadata,
although not all databases implement it. Google for more info.
Recent versions of PostgreSQL support INFORMATION_SCHEMA -- here's
More information about the Python-list