> Rowan Worth wrote: > > You can also filter out specific messages at the shell level: > > sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the > rest with NULL' >&2) > > But note that the >() syntax is not a POSIX sh feature, and will not work > in a script using a shebang of #!/bin/sh. You need to change it to > #!/bin/bash or whatever shell you have on hand. For more info see the > "Process Substition" section of the bash man page. > > If you have the ability to modify the generated SQL, presumably you could > avoid the error by generating a NULL yourself for the missing column? > -Rowan I replied just before reading this. This solution may be preferred.
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users