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
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 |