On 10/22/2010 05:16 AM, Szymon Guz wrote:
Hi,
I still get the same error while using COPY FROM 'file'. I have to pass
the full directory for this to work, example:
Sounds like you want to be using psql's \copy, not the server side COPY.
\copy is aware of your current working directory and does
On 21/10/2010 22:16, Szymon Guz wrote:
Hi,
I still get the same error while using COPY FROM 'file'. I have to pass
the full directory for this to work, example:
COPY first (a,b,c) FROM '1st_file.csv' with csv header delimiter ',';
ERROR: could not open file "1st_file.csv" for reading: No such f
On 21 October 2010 23:28, Raymond O'Donnell wrote:
> On 21/10/2010 22:16, Szymon Guz wrote:
>
>> Hi,
>> I still get the same error while using COPY FROM 'file'. I have to pass
>> the full directory for this to work, example:
>>
>> COPY first (a,b,c) FROM '1st_file.csv' with csv header delimiter '
Le lundi 11 février 2008, Klint Gore a écrit :
> Is there any way to make copy work with fixed width files?
I'll try to see about implementing this in pgloader, shouldn't be complex. But
we have some other things on the TODO (which could get formalized by now...).
So at the moment the preprocess
Klint Gore <[EMAIL PROTECTED]> writes:
> Is there any way to make copy work with fixed width files?
I'd suggest using a simple sed script to convert the data into the
format COPY understands.
regards, tom lane
---(end of broadcast)-
day, April 21, 2000 8:37 AM
To: pgsql-general
Subject: Re: [GENERAL] COPY Question
Disregard this. I went with a temp table solution.
Thanks,
Sam
Bruce Momjian wrote:
>
> > As you can see I'm delimiting the fields with a '|' character. You will
> > also notice that t
