Re: [MonetDB-users] COPY...INTO from remote

On 09-09-2009 16:35:24 -0400, Matthew Jones wrote:

The original suggestion was to use 'mclient' with the '<' redirect operator I'm assuming like this:

mclient -lsql -s "COPY INTO table from STDIN DELIMITERS '\t';" < recordsfile

you could do it in shell, e.g. in bash: { echo "COPY INTO table from STDIN DELIMITERS '\t';" cat recordsfile } | mclient -lsql -ddb -hhost