Re: COPY FROM in psql - Mailing list pgsql-general

From Rob Sargent
Subject Re: COPY FROM in psql
Date
Msg-id 50ABD3EE.60509@gmail.com
Whole thread Raw
In response to Re: COPY FROM in psql  (Matthew Vernon <matthew.vernon@sac.ac.uk>)
List pgsql-general
On 11/20/2012 11:47 AM, Matthew Vernon wrote:
> Matthew Vernon <matthew.vernon@sac.ac.uk> writes:
>
>> naiively, you might try:
>> \set pwd '\'' `pwd` '\''
>> COPY table FROM :pwd || '/relative/path/to/data' ;
>
> I should also note that I want to run a series of these commands, hence
> setting pwd once and then wanting to use it multiple times.
>
> Matthew
>
Since you're resting the full path anyway, does this work?

\set pwd '\'' `pwd` '/rest/of/path\''


pgsql-general by date:

Previous
From: Matthew Vernon
Date:
Subject: Re: COPY FROM in psql
Next
From: Tom Lane
Date:
Subject: Re: COPY FROM in psql