[sqlalchemy] is there a problem in $ and % in a query using engine.execute?

2011-11-21 Thread Krishnakant Mane
Hello all. I am trying to write some code which after creating tables and related views trys to create the stored procedures (plpgsql). code goes some thing like this engine.execute(create or replace function addRecord(f1 text, f2 t1.fieldname%type ) returns bit as $$ ... begin ... end; $$

Re: [sqlalchemy] is there a problem in $ and % in a query using engine.execute?

2011-11-21 Thread Michael Bayer
try escaping the % sign as in %%. this is psycopg2's behavior. On Nov 21, 2011, at 1:27 PM, Krishnakant Mane wrote: Hello all. I am trying to write some code which after creating tables and related views trys to create the stored procedures (plpgsql). code goes some thing like this