[email protected] (Tom Lane) writes: > Matthew Vernon <[email protected]> writes: >> naiively, you might try: >> \set pwd '\'' `pwd` '\'' >> COPY table FROM :pwd || '/relative/path/to/data' ; > > Umm ... why don't you just use a relative path as-is, with \copy > instead of COPY?
Thanks for the suggestion, but I was avoiding \copy because the quantities of data involved are large, and the documentation suggests that COPY is better than \copy for large data volumes. Thanks, Matthew -- Matthew Vernon Quantitative Veterinary Epidemiologist Epidemiology Research Unit, SAC Inverness -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
