Stefan This looks perfect! I will have to experiment with it a bit to see if I really understand, but the documentation seems clear. Time to play. Sorry I didn't find it myself. Thankyou very much. Zoltan Stefan Manegold wrote:
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
-- View this message in context: http://old.nabble.com/simple-load--tp31587056p31594737.html Sent from the monetdb-users mailing list archive at Nabble.com.