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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -