Manlio Perillo ha scritto:
> Hi.
>
> I'm having strange problems when I execute a SHOW command with PostgreSQL.
>
> from sqlalchemy import create_engine, sql, __version__
>
> print __version__
>
> URL = 'postgres://xxx:[EMAIL PROTECTED]/xxx'
> db = create_engine(URL, echo=True)
> conn = db.connect()
>
> query = sql.text('SHOW CLIENT_ENCODING')
> r = conn.execute(query)
> print r.scalar()
>
>
>
I've no problem:
0.3.10
2008-07-07 15:22:29,161 INFO sqlalchemy.engine.base.Engine.0x..d4 SHOW
CLIENT_ENCODING
2008-07-07 15:22:29,161 INFO sqlalchemy.engine.base.Engine.0x..d4 {}
UTF8
do you have the same problem with the fetchall()?
r = conn.execute( 'SHOW CLIENT_ENCODING' )
print r.fetchall()
Glauco
--
+------------------------------------------------------------+
Glauco Uri
glauco(at)sferacarta.com
Sfera Carta Software® info(at)sferacarta.com
Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054
+------------------------------------------------------------+
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
