Nick Upson wrote:

> before I start thinking about writing something that does this, is anyone
> aware of one that already exists.
>
> I want to do "select a,b from mytable where c < 97" and have the output as
> insert statements, automatically, on unix (fedora 8 to be precise)

FBExport with -Si option. Like this:

fbexport -Si -Q "select a,b from mytable where c < 97" -D /path/to/db

More info here:

http://www.firebirdfaq.org/fbexport.php


HTH

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com