From: | Zak McGregor <zak(at)mighty(dot)co(dot)za> |
---|---|
To: | "Hasan Mokhtari" <mokhtari(at)hadid(dot)sharif(dot)ac(dot)ir> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: help request |
Date: | 2001-03-27 14:40:43 |
Message-ID: | 200103271440.QAA01473@zak.home.dom |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 26 Mar 2001 18:44:59 +0430
"Hasan Mokhtari" <mokhtari(at)hadid(dot)sharif(dot)ac(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph | 2001-03-27 14:49:33 | FW: help request |
Previous Message | Christian Marschalek | 2001-03-27 13:58:39 | RE: Supertypes? |