error

[Former user]

Python 2.6.5 (r265:79096, Mar 19 2010, 21:48:26) v.1500 32 bit (Intel) on win32 Type "copyright", "credits" or "license()" for more information.

****************************************************************
Personal firewall software may warn about the connection IDLE
makes to its subprocess using this computer's internal loopback
interface.  This connection is not visible on any external
interface and no data is sent to or received from the Internet.
****************************************************************

IDLE 2.6.5

from sqlalchemy import create_engine, MetaData, Table, Column from sqlalchemy.engine import reflection db_engine = create_engine( 'postgresql+psycopg2://postgres:xxxxxx@localhost:5432/cks')#, echo=True) insp = reflection.Inspector.from_engine(db_engine) insp.get_schema_names() u'public' u'sql_sizing_profiles', u'sql_features', u'sql_implementation_info', u'sql_languages', u'sql_packages', u'sql_parts'

Traceback (most recent call last): File "<pyshell#6>", line 1, in <module> insp.get_columns(u'sql_sizing') File "C:\Python26\lib\site-packages\sqlalchemy-0.6.5-py2.6.egg\sqlalchemy\engine\reflection.py", line 223, in get_columns kw) File "<string>", line 1, in <lambda> File "C:\Python26\lib\site-packages\sqlalchemy-0.6.5-py2.6.egg\sqlalchemy\engine\reflection.py", line 40, in cache ret = fn(self, con, *args, kw) File "C:\Python26\lib\site-packages\sqlalchemy-0.6.5-py2.6.egg\sqlalchemy\dialects\postgresql\base.py", line 982, in get_columns info_cache=kw.get('info_cache')) File "<string>", line 1, in <lambda> File "C:\Python26\lib\site-packages\sqlalchemy-0.6.5-py2.6.egg\sqlalchemy\engine\reflection.py", line 40, in cache ret = fn(self, con, args, *kw) File "C:\Python26\lib\site-packages\sqlalchemy-0.6.5-py2.6.egg\sqlalchemy\dialects\postgresql\base.py", line 896, in get_table_oid raise exc.NoSuchTableError(table_name) NoSuchTableError: sql_sizing

[Mike Bayer]

this is a usage error - please use the mailing list for issues like these in the future, thanks.

e = create_engine('postgresql://scott:tiger@localhost/test', echo=True)
insp = reflection.Inspector.from_engine(e)
insp.get_schema_names()
insp.get_table_names(u'information_schema')
insp.get_columns(u'sql_sizing', schema='information_schema')