TextWrangler: This file doesn’t appear to contain a valid ‘shebang’ line

sql database shebang textwrangler
FranXh picture FranXh · Jun 18, 2013 · Viewed 11.9k times · Source

It is my first time working with TextWrangler. I am using it to open a .sql file. But when I try to run the file I get the following error:

 This file doesn’t appear to contain a valid ‘shebang’ line (application error code: 13304)

I tried to look at some other posts on StackOverflow, and I think I understood that the problem is the insertion of a line that contains the # symbol, but I cannot figure out how to fix it.

The file starts like this:

 BEGIN TRANSACTION;
 INSERT INTO ......

Answer

vilmoskörte picture vilmoskörte · Jul 13, 2013

Textwrangler is not a Database frontend nor can it execute SQL. You must specify a program to be executed when you select run from the menu. And this is done with the shebang line, which, for example, could be "#!/usr/bin/psql" (as first line of the file and w/o the quotes) if you want Postgresql's psql command to execute the SQL statements on a unixoid system.

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More