Re: update table from internet site

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: nasr(dot)laili(at)tin(dot)it
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: update table from internet site
Date: 2004-08-25 18:23:14
Message-ID: 200408251823.i7PINFxg001518@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message DeJuan Jackson 2004-08-25 18:37:44 Re: The Slony General List
Previous Message Greg Stark 2004-08-25 18:15:46 Re: Ordering by IN