stored procedures - Run postgresql script file in python using sqlalchemy -
i used following python scripts run sql script files
open(file_name, 'r') myfile: data = myfile.read().replace('\n', '') self.engine.execute(data)
all files (create tables, views, , stored procedures) work except 1 runs stored procedure.
i can run content of file in postgresql command line, sql script correct. doesn't run file in python program.
Comments
Post a Comment