On the psql man page there is an example of how to perform multiple line
psql script as part of the -c option description.
The example given is
echo "\x \\ select * from foo;" | psql
which gives
prompt> echo "\x \\ select * from foo;" | psql
Expanded display is on.
invalid command \
i.e. doesn't work on bash. With bash the command should be:
echo -e "\x \n select * from foo;" | psql
which gives
prompt> echo -e "\x \n select * from foo;" | psql
Expanded display is on.
ERROR: relation "foo" does not exist
Does this mean there are multiple forms of the echo command, or is this
example just wrong?
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com