Re: simple COPY FROM issue - Mailing list pgsql-general

From brian
Subject Re: simple COPY FROM issue
Date
Msg-id 491B5AAE.3070609@zijn-digital.com
Whole thread Raw
In response to simple COPY FROM issue  ("Kevin Duffy" <KD@wrinvestments.com>)
Responses Re: simple COPY FROM issue
List pgsql-general
The file must be on the server. IIRC, with COPY FROM (as opposed to COPY
TO) the path can be relative to the server process dir but it's probably
a good idea to always use an absolute path.

If you wish to copy from the client machine you can use \copy within psql.

b

Kevin Duffy wrote:
> Hello:
>
>
>
> A follow up question that may clear this all up:
>
>
>
> Is the 'filename' relative to the server machine or the client where
> pgAdmin is running?
>
>
>
>
>
> Kevin Duffy
>
> WR Capital Management
>
> 40 Signal Rd
>
> Stamford, CT
>
> 203-504-6221
>
>
>
>

pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: simple COPY FROM issue
Next
From: Greg Smith
Date:
Subject: Re: sort_mem param of postgresql.conf