Matthew Vernon <matthew.vernon@sac.ac.uk> writes:
> naiively, you might try:
> \set pwd '\'' `pwd` '\''
> COPY table FROM :pwd || '/relative/path/to/data' ;
so I could do:
\set path '\'' `pwd` '/path/to/data1' '\''
COPY table1 FROM :path;
\set path '\'' `pwd` '/path/to/data2' '\''
COPY table2 FROM :path;
...but surely there's a better way?
Matthew
--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness