Skip site navigation (1) Skip section navigation (2)

Re: update table from internet site

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: update table from internet site
Date: 2004-08-25 19:52:26
Message-ID: 20040825195226.GA4222@deby.ei.hnet (view raw or flat)
Thread:
Lists: pgsql-general
* Mike Nolan <nolan(at)gw(dot)tssi(dot)com> [250804, 13:23]:
> > 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.
> 
> You'd probably be better off writing a small program in a language like
> PHP or perl that reads the text file and updates the table.  That way
> the program can deal with bad data and other possible errors.  
> --

Do you mean putting the commands in a script or a more complex program?
[I've no idea about 'programming' in php or perl :-( ] 
	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) ]

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-25 20:06:07
Subject: Re: Timestamp with Timezone
Previous:From: Christopher BrowneDate: 2004-08-25 19:48:20
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group