On Mon, 26 Mar 2001 18:44:59 +0430
"Hasan Mokhtari" <mokhtari@hadid.sharif.ac.ir> wrote:
> hello dear.
> I want to run the following command
> " copy table1 form /tmp/table1.aa using delimiters '|';
> but I cant because I am not 'postgres' user and have not this privilage;
> 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?
> thanks a lot;
>
>
Perhaps you should quote the filename thus:
\copy table1 from '/tmp/table1.aa' using delimiters '|';
HTH
ciao
Zak