Re: help request - Mailing list pgsql-general

From Zak McGregor
Subject Re: help request
Date
Msg-id 200103271440.QAA01473@zak.home.dom
Whole thread Raw
In response to help request  ("Hasan Mokhtari" <mokhtari@hadid.sharif.ac.ir>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: help request
Next
From: "Matthew Brown"
Date:
Subject: RE: Free PostgreSQL Database Hosting - Needs Beta Testers