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

From Matthew Vernon
Subject Re: COPY FROM in psql
Date
Msg-id 877gpftgw2.fsf@macbeth.sac.ac.uk
Whole thread Raw
In response to COPY FROM in psql  (Matthew Vernon <matthew.vernon@sac.ac.uk>)
List pgsql-general
tgl@sss.pgh.pa.us (Tom Lane) writes:

> Matthew Vernon <matthew.vernon@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


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: PostgreSQL training recommendations?
Next
From: Chris Travers
Date:
Subject: Re: PostgreSQL training recommendations?