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:39:40
Message-ID: alpine.LNX.2.00.1102021139010.4447@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
On Wed, 2 Feb 2011, Darrell Fuhriman wrote:

> \c is not short for "copy" it's short for "connect" That's why you're getting the error.

   Ah, I miss-read the command.

> COPY (without the backslash) only works the file is directly accessible by
> the postgres process on the server. \copy allows you to get the same
> functionality using any file the *client* has access to. They're very
> different things.

   Server and client are on the same host here.

Rich

In response to

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-02 19:44:28
Subject: Re: COPY command syntax error [SOLVED]
Previous:From: TimDate: 2011-02-02 19:38:28
Subject: Re: COPY command syntax error

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