Zoltan, I'm not sure whether I understand your question correctly, but yes, MonetDB's mclient can read SQL statements from ascii text files, and hence read also creats schema and create table statements from ascii text files to create schemas and tables. See [1] and/or `man mclient` for more details. Also, the copy into statement [2] is the recommended way to efficiently bulk-load data fro text (csv) files. I hope this answers your question and helps you further Stefan [1] http://monetdb.cwi.nl/SQL/Documentation/MAPI-Client.html [2] http://monetdb.cwi.nl/SQL/Documentation/Data-Manipulation.html On Tue, May 10, 2011 at 09:21:37AM -0700, Zoltan Tomory wrote:
Sorry to be a bother, but I wonder how hard it is to load a schema or table from ascii text or an .mdb "access" file. I am using the convenient simple console client that is included. Upon searching the list archives, I found some leads which lead me to panic and reflexively consider using Java's Robot class to perform row by row insert operations from the text file.
I'm hopeful that there is another way which is both elegant and understandable to a newbie.
Thanks in advance. I have loved using MonetDB to organize my information
Zoltan -- View this message in context: http://old.nabble.com/simple-load--tp31587056p31587056.html Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |