HSQLDB can write tables to CSV files, which I heavily use in CsvCruncher.
However, when I tried to point HSQLDB to /dev/stdout as a target for the CSV table, it turned out that it's more than a simple dump - it does seeks.
DB error: SQLException bad TEXT table source file - line number: 0 org.hsqldb.HsqlException: file input/output error openning file: /dev/pts/3 error: java.io.IOException: Illegal seek in statement [SET TABLE "te_out" SOURCE '/dev/pts/3;encoding=UTF-8;cache_rows=50000;cache_size=10240000;ignore_first=true;fs=,;qc=\quote' ]
Is it possible to make HSQLDB dump a table to CSV using the SET TABLE ... SOURCE? Perhaps using some write-only flag, or such?
Note: I am not looking for a CSV export, as that would mean first creating the table, and then exporting it, which is a performance drawback.