On Wed, 2004-08-18 at 16:26, Bob Parkinson wrote:
> I've started to use the "here document" idea a lot when writing scripts to do tasks.
>
> #!/usr/local/bin/bash
>
> psql -d myDB <<EOSQL
>
> select foo ....
> update bar;
> delete from ...
>
> EOSQL
If the here document is long and complicated, you should make that
command line
psql -d myDB -f - <<EOSQL
so as to get the line number of any error (counting from the start of
the here document).