Subject Re: [ib-support] importing lots of rows
Author Helen Borrie
At 02:47 PM 09-04-02 +0200, you wrote:
>Is there a tool similar to bcp (sybase) or COPY (postgresql) for
>I started looking at Firebird, and didn't find any reference to such a

Similar...but not identical - but if you can export your data in fixed
format, you can define the output file inside the database as an external
table. You can either assign data types right off (if you have fields that
are castable) or you can read it in as chars and select it into another
table with castings, using DSQL or a stored procedure. I nearly always use
the second route because it allows me to validate the incoming data at the
same time. The datapump tool in IB_SQL (free at is
great for this as you can do a very fine-grained conversion.

Apart from that, there are numerous third-party tools around which can be
used. (Third-party tools are the life-blood of Firebird!) Check out the
Contributed Downloads page at the ibphoenix site -


All for Open and Open for All
Firebird Open SQL Database · ·