"Hasan Mokhtari" <mokhtari@hadid.sharif.ac.ir> writes:
> If I use follawing command instead:
> " \copy table1 form /tmp/table1.aa using delimiters '|';
> psql report follawing error :
> "extra token after file name "
> what I can do?
Leave out the semicolon (';') at the end. In general, psql's backslash
commands do not use a terminating semicolon --- they just end at the
end of the line.
Also, if you are using a version before 7.0, you may need to update.
I don't think psql supported "using delimiters" in \copy before 7.0.
regards, tom lane