Hello Dariusz,
Such a feature seems to be very tailored to your specific situation,
and will probably not make it into MonetDB (my guess). If you would
like such a feature, perhaps preprocess your data with a 12-line
python script, such as the one below, or anything similar.
Cheers,
Wouter
import sys
numFields = 3
delim = '\t'
def emitTuple(cells):
sys.stdout.println(delim.join(cells)
cells = []
for line in sys.stdin:
cells += line
if len(cells) == numFields:
emitLines(cells)
cells = []
2009/1/21 dariuszs
Hi, Well I can output a table as a flat file like this: copy select col1,col2,col3 from table1 into 'c:\flat_file.txt' using delimiters '','\x0D\x0a','';
So I was wondering if I can do the same thing for the input like this: copy from 'c:\flat_input.txt' into table2 using delimiters '','\x0D\x0a',''; It says: don't use delimiters, use 0D0A for record delimiters, don't use qualifiers
It would be nice to have such a feature. Thanks. Dariusz.
Stefan Manegold wrote:
On Wed, Jan 21, 2009 at 10:11:40AM -0500, dariuszs wrote:
Hello, Is there any way to copy flat file into the table not using delimiters?
I'm now aware that SQL standard covers such functionality, let alone how is should work. How are attribute- and record- boundaries to be identified other than by delimiters? Using only fixed-width datatypes AND attribute values? (The latter requiring explicit white-space(?) padding in the flat data file and implicite white-space trimming during load?)
Stefan
Thanks. Dariusz.
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users