Subject | Re: [firebird-support] Import data from flat files |
---|---|
Author | Milan Babuskov |
Post date | 2003-09-29T18:36:22Z |
Oleg Lebedev wrote:
(easy to do with some small script in C, PHP, whatever) and then attach
it as external table. After that just do:
INSERT INTO real_table (column_list, ...)
SELECT column_list,... FROM external_table;
It works really fast.
HTH
--
Milan Babuskov
http://fbexport.sourceforge.net
> I was under the impression that plain INSERTs would be too slow for theExternal tables. You have to reformat your data from CSV to fixed length
> amount of data I need to import. That's why SQL Server has a BCP
> utility, PostgreSQL has a COPY utility. Does FireBird have any similar
> utility that would do a bulk copy for me?
(easy to do with some small script in C, PHP, whatever) and then attach
it as external table. After that just do:
INSERT INTO real_table (column_list, ...)
SELECT column_list,... FROM external_table;
It works really fast.
HTH
--
Milan Babuskov
http://fbexport.sourceforge.net