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

From Matthew Vernon
Subject Re: COPY FROM in psql
Date
Msg-id 87r4not8ku.fsf@macbeth.sac.ac.uk
Whole thread Raw
In response to COPY FROM in psql  (Matthew Vernon <matthew.vernon@sac.ac.uk>)
Responses Re: COPY FROM in psql
List pgsql-general
Matthew Vernon <matthew.vernon@sac.ac.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

--
Matthew Vernon
Quantitative Veterinary Epidemiologist
Epidemiology Research Unit, SAC Inverness


pgsql-general by date:

Previous
From: Matthew Vernon
Date:
Subject: COPY FROM in psql
Next
From: Rob Sargent
Date:
Subject: Re: COPY FROM in psql