well if you are referring to the "information schema" that postgres
uses, only postgres has that specific schema represented within it
(and its also quite complicated). Mysql seems to support a slightly
different version of it and also one that doenst seem to work
completely. other databases that I know of have no notion of that
particular style of information schema (oracle for example has the
data dictionary which is completely different).
by "information schema" you mean just some genericized way to get at
major schema objects ? or specifically the one presented in
postgres' set of tables ? if you are just looking for a more open-
ended way to access the listings of tables, columns, indexes, etc.,
other than constructing a Table or Index, thats not necessarily a bad
thing. I can help with API design on this if you have a proposal in
mind. Im also really hoping someone wants to chip in on the existing
schema reflection if not this new idea as well, currently table
reflection is only functional for sqlite, postgres, and mysql 5.
On Jan 10, 2006, at 8:19 PM, [EMAIL PROTECTED] wrote:
Hi,
I would like to make the information schema
more directly accessible. It appears that
currently this is only used for the
'reflecttable' method to introspect table
definitions.
Based on my current understanding of
sqlalchemy I think it would be reasonable
for SQLEngine instances to have an
'ischema' attribute that allows one
to access these tables in the following
way:
engine = create_engine('...')
c = engine.ischema.columns
c.select(c.c.table_name=='foo')
I'm wondering if there's general interest
in such functionality, and whether there
are better APIs for presenting the info
to the user.
Thanks,
d
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through
log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
