Data from Internet direct into PostgeSQL Database??
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
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@freesurf.fr> wrote in message
news:327fd.0411150539.f6c7673@posting.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';
Show quoted text
Would be great if you could help me!
THX
Christian Meier
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@nospam.com> wrote in message
news:cnacin$but$1@news.hub.org...
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@freesurf.fr> wrote in message
news:327fd.0411150539.f6c7673@posting.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=
Show quoted text
3&b=5&c=1991&ignore=.csv';
Would be great if you could help me!
THX
Christian Meier