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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2011-02-02 19:44:28 Re: COPY command syntax error [SOLVED]
Previous Message Tim 2011-02-02 19:38:28 Re: COPY command syntax error