import pyctree
conn = pyctree.connect( host='localhost', port='6597', user='admin', password='ADMIN', database='ctreeSQL' )
conn._set_autocommit(True)
curs = conn.cursor()
curs.execute( "SELECT * FROM admin.syscolumns" )
results = curs.fetchall()
for r in results:
print r[1]
curs.close()
conn.close()