Are you sure you have the names correct? There is no "name" column on a "database" table on PostgreSQL by default. And it is also an interesting name choice to name the PostgreSQL configuration file as "ora.cfg"...
-- Jorge Godoy <jgo...@gmail.com> On Fri, Oct 28, 2011 at 11:44, jo <jose.soa...@sferacarta.com> wrote: > Hi all, > > I'm trying to write a script to access to PostgreSQL and Oracle, like this: > > # -*- coding: utf-8 -*- > import turbogears > from turbogears.database import get_engine > > #PostgreSQL... > turbogears.update_config(**configfile='ora.cfg', > modulename="sicer.config") > sql='select name from database' > engine = get_engine() > print engine.execute(sql).fetchall() > > #Oracle... > turbogears.update_config(**configfile='dev.cfg', > modulename="sicer.config") > sql='select name from database' > engine = get_engine() > print engine.execute(sql).fetchall() > > > I was hoping to be logged on to the 2 databases, one at a time, but... > > > [(u'Oracle v10g',)] > > > [(u'Oracle v10g',)] > > > Could someone help me? > > j > > -- > You received this message because you are subscribed to the Google Groups > "TurboGears" group. > To post to this group, send email to turbogears@googlegroups.com. > To unsubscribe from this group, send email to turbogears+unsubscribe@** > googlegroups.com <turbogears%2bunsubscr...@googlegroups.com>. > For more options, visit this group at http://groups.google.com/** > group/turbogears?hl=en <http://groups.google.com/group/turbogears?hl=en>. > > -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to turbogears@googlegroups.com. To unsubscribe from this group, send email to turbogears+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/turbogears?hl=en.
