Обсуждение: Re: Data from Internet direct into PostgeSQL Database??
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'; > > 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= > 3&b=5&c=1991&ignore=.csv'; > > > > Would be great if you could help me! > > > > THX > > Christian Meier > >