8 Apr
2010
8 Apr
'10
5:06 p.m.
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