Until now i did all my db queries with the DAL from web2py. But first the first i now got a raw sql file that needs to be execute at a certain point. In the terminal i use the '\i' command to import and execute a sql script.
If i try to use this with db.executesql("\i /path/to/file.sql") i get an error: => CESTERROR: syntax error at or near "\" at character 1 . Escaping the character "\\i" doesn't help, still got the same error. Using psql from the system() call doesn't help (i don't have i currently installed =] ). Does someone ever came across this problem before?