Subject Re: [firebird-support] Import data from flat files
Author Milan Babuskov
Oleg Lebedev wrote:

> Ok, great.
> I am wondering if there is a way to execute an SQL command through some
> FB utiltity from a shell. Smth like:
> bash> time isql -c "SELECT count(*) FROM tableA" /tmp/mydb.fdb

You can either put it in some file (ex. file.sql) and do something like

isql -i file.sql /tmp/mydb.fdb

Since isql reads input from stdin, I guess you can do one-liners like this:

echo "SELECT count(*) from tableA" | isql /tmp/mydb.fdb

Haven't tried it though...

Milan Babuskov