On 11/20/2012 11:47 AM, Matthew Vernon wrote:
> Matthew Vernon <matthew(dot)vernon(at)sac(dot)ac(dot)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\''