No, he would have to run the java app to format the file and then su as postgres to be able to \i it into the database.
Colin
On Thursday, Aug 22, 2002, at 06:27PM, Ryan Cuprak <email@hidden> wrote:
>
>Why do you have to su as postgres in order to run the java app?
>
>-Ryan
>
>On Wed, 21 Aug 2002, Colin Jackson wrote:
>
>> Hi everybody,
>> I have set up an SQL database for work. I need to set something up to allow my boss to add records once a month. This will be a batch of about 3000 - 4000 records. Does anyone know of a good way of doing this.
>>
>> The records are exported from the accounts program and I have already written a java program to format this output and add "insert into...". This allows me to simply \i the file. It is all still too complicated for my boss though (requires su-ing as postgress running java programs finding the file etc).
>>
>> I'd prefer not to use JDBC because it seems far too complicated for what I want to do and I'd need to recompile postgres.
>>
>> Any help would be great, thanks,
>>
>> Colin
>> _______________________________________________
>> studentdev mailing list | email@hidden
>> Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/studentdev
>> Do not post admin requests to the list. They will be ignored.
_______________________________________________
studentdev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/studentdev
Do not post admin requests to the list. They will be ignored.