Data from Internet direct into PostgeSQL Database??

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • chris
    #1

    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=TKA G.DE&d=10&e=15& f=2004&g=d&a=3& b=5&c=1991&igno re=.csv';

    Would be great if you could help me!

    THX
    Christian Meier
    Tags: None
    • Sim Zacks
      #2
      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@free surf.fr> wrote in message
      news:327fd.0411 150539.f6c7673@ posting.google. com...[color=blue]
      > Hi!
      >
      > Is there any Way or have somebody a Function to do something like this
      > copy skurs from[/color]
      'http://ichart.finance. yahoo.com/table.csv?s=TKA G.DE&d=10&e=15& f=2004&g=d&a=
      3&b=5&c=1991&ig nore=.csv';[color=blue]
      >
      > Would be great if you could help me!
      >
      > THX
      > Christian Meier[/color]


        Comment

        • Sim Zacks
          #3
          Re: Data from Internet direct into PostgeSQL Database??

          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 ...[color=blue]
          > You can have a cron job download the file to your local machine and then[/color]
          use[color=blue]
          > 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@free surf.fr> wrote in message
          > news:327fd.0411 150539.f6c7673@ posting.google. com...[color=green]
          > > Hi!
          > >
          > > Is there any Way or have somebody a Function to do something like this
          > > copy skurs from[/color]
          >[/color]
          'http://ichart.finance. yahoo.com/table.csv?s=TKA G.DE&d=10&e=15& f=2004&g=d&a=[color=blue]
          > 3&b=5&c=1991&ig nore=.csv';[color=green]
          > >
          > > Would be great if you could help me!
          > >
          > > THX
          > > Christian Meier[/color]
          >
          >[/color]


            Comment

            Previous template Next
            Working...