Re: [MonetDB-users] Create Database - Load Data

You probably intend to use the redirect offered by the mclient tool? 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