| 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: | Whole Thread | Raw Message | 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? |