On Fri, Jul 18, 2014 at 05:51:35PM +0200, Francisco Olarte wrote: > Anyway, this is a little bit complex, as psql many times needs arguments. Agreed. > > Could we please have the PostgreSQL lexer treat #!... on the first line of a > > file as a comment? This would enable .psql scripts to be run with dot-slash > > notation ... > It's been pointed it can be done with a shell script. If you can live > with a little noise you can have it dual ( The \r makes it ignore the > previous lines, the \q makes it exit before reading the EOF line ): > > ~/tmp $ cat kk.sql > #!/bin/bash > psql service=redacted <<EOF > \r > select 2*3*7; > \q > EOF Nice solution but that won't work on Windows ... Karsten -- GPG key ID E4071346 @ gpg-keyserver.de E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
