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