On 6/2/11 8:27 AM, Martin Kersten wrote:
You probably intend to use the redirect offered by the mclient tool?
You might have a look at http://www.monetdb.org/Downloads/Tutorial which describes its use.
shell> mclient Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.4.0, 'mTests_benchmarks_wisconsin' Type \q to quit, \? for a list of available commands auto commit mode: on sql>\? \? - show this message \
file - save response in file, or stdout if no file is given \|cmd - pipe result to process, or stop when no command is given \h - show the readline history \t - toggle timer \D table- dumps the table, or the complete database if none given. \d[Stvsfn]+ [obj] - list database objects, or describe if obj given \A - enable auto commit \a - disable auto commit \e - echo the query in sql formatting mode \f - format using a built-in renderer {csv,tab,raw,sql,xml} \w# - set maximal page width (-1=unlimited, 0=terminal width,>0=limit to num) \r# - set maximum rows per page (-1=raw) \L file - save client/server interaction \X - trace mclient code \q - terminate session On 6/2/11 8:18 AM, Lowterm wrote:
Hi Martin,
thanks for your reply but it can't help me. I could not find any example and solution for my problem. I would like to import SQL-Tabels with contents to MonetDB and not from MonetDB to a File to import in SQL. My SQL-File should be invoked from MonetDB and the Tables with contents should be created automatically in my database within MonetDB. Is that possible? I need a example please.
Thanks
------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users