On 2012-11-21, Matthew Vernon wrote:
> t...@sss.pgh.pa.us (Tom Lane) writes:
>
>> Matthew Vernon 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
>> inste
t...@sss.pgh.pa.us (Tom Lane) writes:
> Matthew Vernon 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 wa
Matthew Vernon writes:
> naiively, you might try:
> \set pwd '\'' `pwd` '\''
> COPY table FROM :pwd || '/relative/path/to/data' ;
so I could do:
\set path '\'' `pwd` '/path/to/data1' '\''
COPY table1 FROM :path;
\set path '\'' `pwd` '/path/to/data2' '\''
COPY table2 FROM :path;
...but surely
Matthew Vernon 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?
\copy table from 'relative/path/to/data'
The server-side COPY is likely to
On 11/20/2012 11:47 AM, Matthew Vernon wrote:
Matthew Vernon 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 multip
Matthew Vernon 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
Quant
Hi,
suppose for a moment I want to write a psql script that loads some data
into a database. I don't want to write an absolute path into my script,
but merely know where the data file will be relative to my script
location.
naiively, you might try:
\set pwd '\'' `pwd` '\''
COPY table FROM :pwd ||
