update table from internet site

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: update table from internet site
Date: 2004-08-25 18:10:21
Message-ID: 20040825181021.GA1212@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
I'm thinking about creating a table listing my shares (say 'Shares') and
then update its price column from a .txt file (say 'Prices') downloaded
from an internet site periodically.
Recalling past readings my first idea would be to use
something like:
=> update table Shares set price = (select price from Prices)
where
Shares.name = Prices.name;
and, of course, table Prices would be re-construed each time as a
=> copy Prices from raw.dowld.txt
My question is:
. Is there a better way to do that?
. Is it possible to introduce any automation in the process?

Your suggestions (even to docs/how-tos) shall be appreciated.
Regards,
Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (used to say Henry Miller) ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2004-08-25 18:15:46 Re: Ordering by IN
Previous Message Marc G. Fournier 2004-08-25 18:05:16 Re: The Slony General List