t...@sss.pgh.pa.us (Tom Lane) writes: > Matthew Vernon <matthew.ver...@sac.ac.uk> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
