Re: psql COPY with JDBC

Hi Dave-

Thanks for the patch. Is it best to use the code base from this gz or
should I attempt to apply the patch to the current code base?

Since the patch is so old, is there a preferred way to get at this
functionality?

-Chris

________________________________

From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
Sent: Monday, April 03, 2006 4:04 PM
To: Christopher Condit
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] psql COPY with JDBC

Yeah, there is a patch, this is rather old now but will do copy.

http://download.postgresintl.com/copy.tar.gz

Dave

On 3-Apr-06, at 4:36 PM, Christopher Condit wrote:

Hi All-

I've been trying over at the general postgres list with no luck, so I
thought I'd try here. I need to bulk load results from a Java
application on one machine to a postgres db on a remote server. I know
I can use psql interactively to accomplish this, but I'd like to be able
to do it programmatically:

1) Is there a better way to accomplish this than the above patch -
with or without JDBC?

Thanks for your time!

Chris

Chris,

It's not *that* old, it should apply to the latest code base without
too much effort. If you do can you send me the most current patch.

Either way it will work

Dave
On 3-Apr-06, at 7:07 PM, Christopher Condit wrote:

> Hi Dave-
>
> Thanks for the patch. Is it best to use the code base from this gz
> or should I attempt to apply the patch to the current code base?
>
> Since the patch is so old, is there a preferred way to get at this
> functionality?
>
>
>
> -Chris
>
>
>
> From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
> Sent: Monday, April 03, 2006 4:04 PM
> To: Christopher Condit
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] psql COPY with JDBC
>
>
>
> Yeah, there is a patch, this is rather old now but will do copy.
>
>
>
> http://download.postgresintl.com/copy.tar.gz
>
>
>
> Dave
>
> On 3-Apr-06, at 4:36 PM, Christopher Condit wrote:
>
>
>
>
> Hi All-
>
> I’ve been trying over at the general postgres list with no luck, so
> I thought I’d try here. I need to bulk load results from a Java
> application on one machine to a postgres db on a remote server. I
> know I can use psql interactively to accomplish this, but I’d like
> to be able to do it programmatically:
>
> 1) Is there a better way to accomplish this than the above
> patch – with or without JDBC?
>
>
>
> Thanks for your time!
>
>
>
> Chris
>
>
>
>
>
>
>

Probably a dumb question, but is there any reason this patch hasn't
been committed to the base JDBC code?

On Apr 3, 2006, at 6:15 PM, Dave Cramer wrote:
> Chris,
>
> It's not *that* old, it should apply to the latest code base
> without too much effort. If you do can you send me the most current
> patch.
>
> Either way it will work
>
> Dave
> On 3-Apr-06, at 7:07 PM, Christopher Condit wrote:
>
>> Hi Dave-
>>
>> Thanks for the patch. Is it best to use the code base from this
>> gz or should I attempt to apply the patch to the current code base?
>>
>> Since the patch is so old, is there a preferred way to get at this
>> functionality?
>>
>>
>>
>> -Chris
>>
>>
>>
>> From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
>> Sent: Monday, April 03, 2006 4:04 PM
>> To: Christopher Condit
>> Cc: pgsql-jdbc(at)postgresql(dot)org
>> Subject: Re: [JDBC] psql COPY with JDBC
>>
>>
>>
>> Yeah, there is a patch, this is rather old now but will do copy.
>>
>>
>>
>> http://download.postgresintl.com/copy.tar.gz
>>
>>
>>
>> Dave
>>
>> On 3-Apr-06, at 4:36 PM, Christopher Condit wrote:
>>
>>
>>
>>
>> Hi All-
>>
>> I’ve been trying over at the general postgres list with no luck,
>> so I thought I’d try here. I need to bulk load results from a
>> Java application on one machine to a postgres db on a remote
>> server. I know I can use psql interactively to accomplish this,
>> but I’d like to be able to do it programmatically:
>>
>> 1) Is there a better way to accomplish this than the above
>> patch – with or without JDBC?
>>
>>
>>
>> Thanks for your time!
>>
>>
>>
>> Chris
>>
>>
>>
>>
>>
>>
>>
>

--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

Jim,

Yeah, it duplicates the executor code so that it is two places.
Ideally it should only be in one place.

Dave
On 6-Apr-06, at 10:26 PM, Jim Nasby wrote:

> Probably a dumb question, but is there any reason this patch hasn't
> been committed to the base JDBC code?
>
> On Apr 3, 2006, at 6:15 PM, Dave Cramer wrote:
>> Chris,
>>
>> It's not *that* old, it should apply to the latest code base
>> without too much effort. If you do can you send me the most
>> current patch.
>>
>> Either way it will work
>>
>> Dave
>> On 3-Apr-06, at 7:07 PM, Christopher Condit wrote:
>>
>>> Hi Dave-
>>>
>>> Thanks for the patch. Is it best to use the code base from this
>>> gz or should I attempt to apply the patch to the current code base?
>>>
>>> Since the patch is so old, is there a preferred way to get at
>>> this functionality?
>>>
>>>
>>>
>>> -Chris
>>>
>>>
>>>
>>> From: Dave Cramer [mailto:pg(at)fastcrypt(dot)com]
>>> Sent: Monday, April 03, 2006 4:04 PM
>>> To: Christopher Condit
>>> Cc: pgsql-jdbc(at)postgresql(dot)org
>>> Subject: Re: [JDBC] psql COPY with JDBC
>>>
>>>
>>>
>>> Yeah, there is a patch, this is rather old now but will do copy.
>>>
>>>
>>>
>>> http://download.postgresintl.com/copy.tar.gz
>>>
>>>
>>>
>>> Dave
>>>
>>> On 3-Apr-06, at 4:36 PM, Christopher Condit wrote:
>>>
>>>
>>>
>>>
>>> Hi All-
>>>
>>> I’ve been trying over at the general postgres list with no luck,
>>> so I thought I’d try here. I need to bulk load results from a
>>> Java application on one machine to a postgres db on a remote
>>> server. I know I can use psql interactively to accomplish this,
>>> but I’d like to be able to do it programmatically:
>>>
>>> 1) Is there a better way to accomplish this than the above
>>> patch – with or without JDBC?
>>>
>>>
>>>
>>> Thanks for your time!
>>>
>>>
>>>
>>> Chris
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
>
>