Subject Re: [firebird-support] Exporting insert statements - qli?
Author Uwe Grauer
Smarts Broadcast Systems wrote:
> I'm doing my best to read the ``qli_syntax.pdf'' manual but am finding
> the going rough, hence this plea for help.
>
> The goal is to dump the contents of a table into a text file of
> ``INSERT'' statements. There are mentions of such capabilities with
> third-party GUI tools but I am hoping that a non-graphical, scriptable
> command-line tool such as ``qli'' already has that capability.

fbexport can do that.

* export and import data from Firebird databases
* command line and GUI version
* runs on Windows and Linux
* export to comma separated values (CSV) format
* export as INSERT statements
* use exported data in DML statements
* handles NULLs and BLOBs properly
* ability to execute sql scripts from a file

See: http://fbexport.sourceforge.net/

Uwe