Extend INSERT INTO to support csv
---------------------------------
Key: CORE-5818
URL: http://tracker.firebirdsql.org/browse/CORE-5818
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Affects Versions: 3.0.4
Reporter: Karol Bieniaszewski
I know that someone can think that this is tool feature like isql or something
like this.
But it can not have same performance like engine itself have.
It should be as fast as it is for external tables now - but as we know external
tables can work only with fixed width data.
Extending external tables to csv data i suppose is not simple task at all.
now we can e.g.:
-----------------------------------
INSERT INTO TEST_TABLE(ID, NAME)
SELECT ID, NAME FROM EXT_TABLE
-----------------------------------
please consider extended syntax for INSERT INTO to:
by index:
INSERT INTO TEST_TABLE(ID, NAME) FROM FILE 'XXX.scv' DELIMITED BY '\t'
HEADER=True COLUMNS(1,3);
by header column names:
INSERT INTO TEST_TABLE(ID, NAME) FROM FILE 'XXX.scv' DELIMITED BY '\t'
COLUMNS('SOL_ID', 'CONT_SUFFIX'); <- here header can not be false because we
use names
It will be really usefull for importing data into Firebird database
>From security reason location of csv should be restricted to e.g. external
>table locations specified already in Firebird.conf
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
