Re: help request

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 15:31:01
Message-ID: 5356.985707061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Hasan Mokhtari" <mokhtari(at)hadid(dot)sharif(dot)ac(dot)ir> writes:
> 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?

Leave out the semicolon (';') at the end. In general, psql's backslash
commands do not use a terminating semicolon --- they just end at the
end of the line.

Also, if you are using a version before 7.0, you may need to update.
I don't think psql supported "using delimiters" in \copy before 7.0.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-27 15:36:26 Re: Re: Call for platforms
Previous Message Oliver Elphick 2001-03-27 15:19:32 Re: help request