Re: help request

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

In response to

Browse pgsql-general by date

  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?