Re: needed tapes

>>>>> On Fri, 14 Mar 2025 14:21:15 +0000, Bill Arlofski via Bacula-users said:
> 
> In a script, you can do:
> 
> 
> echo -e "sql\nSELECT......ORDER BY volumename INC;\n\nquit\n" | bconsole
> 
> 
> The echo -e: enable interpretation of backslash escapes
> 
> The `\n` in the script are line feeds.  The two `\n\n` in a row get you out of the bconsole SQL interface.

Beware that echo is a minefield.  Support for the -e option (and even handling
of \ without -e) is not standardized across all shells.  For example, /bin/sh
on Debian defaults to dash, which doesn't support -e and always treats \n as a
newline.  This is the opposite of bash.

The simplest solution is use the POSIX printf utility instead of echo.

If you still think echo is a good idea and want to be sure to get newlines,
then you can use multiple commands:

( echo "sql"; echo "SELECT......ORDER BY volumename INC;"; echo; echo "quit" ) | bconsole

__Martin