Andrew,
> We are thinking of redeveloping our 500 program text based SOP POP
> Stock etc
> application that uses 2000 flat files.
About time! :-)
> We think we want to use Linux / Postgres & as a for the lanuage we
> have no
> idea although someone here has suggested C.
You could also use Java, Tcl, C++, PHP, and/or Perl depending on what
your needs are and what programmers you have. Python and Kylix/Delphi
also have good DB interfaces. Smalltalk even has its adherents. Heck,
you could run it on Win 2000 and use VB.NET (but I wouldn't reccomend it
for sake of your sanity).
> Does anyone know any good books to buy
Yes. See http://techdocs.postgresql.org/bookreviews.php
Particularly Wrox Press's book seems suited to your needs.
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco