How to run sql script in geany?

Question

I am able to run my ex1.sql script from the command line, but in geany the follow error pops up:

./geany_run_script.sh: 5: ./geany_run_script.sh: ./ex1: not found

Does anyone have an idea?

Answer 1

Geany cannot execute sql directly. You have to configure the Build Commands from inside the build menu to do this e.g. to psql -f %f to run sql script with psql client.