Re: COPY FROM in psql

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: COPY FROM in psql
Дата
Msg-id 50ABD3EE.60509@gmail.com
обсуждение исходный текст
Ответ на Re: COPY FROM in psql  (Matthew Vernon <matthew.vernon@sac.ac.uk>)
Список pgsql-general
On 11/20/2012 11:47 AM, Matthew Vernon wrote:
> 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
>
Since you're resting the full path anyway, does this work?

\set pwd '\'' `pwd` '/rest/of/path\''


В списке pgsql-general по дате отправления:

Предыдущее
От: Matthew Vernon
Дата:
Сообщение: Re: COPY FROM in psql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY FROM in psql