Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-02 19:35:56
Subject: Re: COPY command syntax error
Previous:From: gabrielleDate: 2011-02-02 19:31:07
Subject: Re: COPY command syntax error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group