Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
Re: Dumping a lot of data into SQL
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Dumping a lot of data into SQL



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.



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.