Hi,

I'm trying to load data using copy command and STDIN source in command line but the process ends without waiting for records. I think this is first step to load data from a second process without using file source.

Here is the command:
mclient -l sql -d database -u user -P pwd -s "COPY INTO table FROM STDIN"
It returns immediately with exit code 0.

With postgresql, the "same" command (psql -U user -h host database -c "\copy table from STDIN") prompt for datas and wait until antislash-dot ("\.") input ends records so it allows a process to load datas using STDIN.

Do you think this is possible with mclient sql copy command?

Regards,
Matthieu