Re: COPY command syntax error

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: COPY command syntax error
Date: 2011-02-02 19:31:41
Message-ID: alpine.LNX.2.00.1102021128150.4447@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Wed, 2 Feb 2011, Darrell Fuhriman wrote:

> I think you want to add a backslash in front of that "copy."

Darrell,

I thought that 'copy' and '\c' were equivalent. The postgres docs show
examples using copy and not the psql \c.

Regardless, when I try \c I get a port warning and no data added:

jerrittwq=# \c monitor from
'/home/rshepard/projects/queenstake/permitwatch/water-quality-info/csv_versions/import.csv'
with delimiter as ':' csv;
invalid port number: "with"
Previous connection kept

Thanks,

Rich

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-02 19:35:56 Re: COPY command syntax error
Previous Message gabrielle 2011-02-02 19:31:07 Re: COPY command syntax error