dbTalk Databases Forums  

Data from Internet direct into PostgeSQL Database??

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Data from Internet direct into PostgeSQL Database?? in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chris
 
Posts: n/a

Default Data from Internet direct into PostgeSQL Database?? - 11-15-2004 , 07:39 AM






Hi!

Is there any Way or have somebody a Function to do something like this
copy skurs from 'http://ichart.finance.yahoo.com/table.csv?s=TKAG.DE&d=10&e=15&f=2004&g=d&a=3&b=5&c =1991&ignore=.csv';

Would be great if you could help me!

THX
Christian Meier

Reply With Quote
  #2  
Old   
Sim Zacks
 
Posts: n/a

Default Re: Data from Internet direct into PostgeSQL Database?? - 11-15-2004 , 07:55 AM






You can have a cron job download the file to your local machine and then use
the copy command to process it into your tables. I don't think that copy
would be able to handle an Internet location, though I could be wrong.


"chris" <tomtailor (AT) freesurf (DOT) fr> wrote

Quote:
Hi!

Is there any Way or have somebody a Function to do something like this
copy skurs from
'http://ichart.finance.yahoo.com/table.csv?s=TKAG.DE&d=10&e=15&f=2004&g=d&a=
3&b=5&c=1991&ignore=.csv';
Quote:
Would be great if you could help me!

THX
Christian Meier



Reply With Quote
  #3  
Old   
Sim Zacks
 
Posts: n/a

Default Re: Data from Internet direct into PostgeSQL Database?? - 11-15-2004 , 07:58 AM



Of course you would only want a cron job if you wanted to automate the
process. Otherwise you would just download the file and save it and then use
the copy command.


"Sim Zacks" <sim (AT) nospam (DOT) com> wrote

Quote:
You can have a cron job download the file to your local machine and then
use
the copy command to process it into your tables. I don't think that copy
would be able to handle an Internet location, though I could be wrong.


"chris" <tomtailor (AT) freesurf (DOT) fr> wrote in message
news:327fd.0411150539.f6c7673 (AT) posting (DOT) google.com...
Hi!

Is there any Way or have somebody a Function to do something like this
copy skurs from

'http://ichart.finance.yahoo.com/table.csv?s=TKAG.DE&d=10&e=15&f=2004&g=d&a=
3&b=5&c=1991&ignore=.csv';

Would be great if you could help me!

THX
Christian Meier





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.