On 19 Jan 2010, at 12:16, Jayadevan M wrote: > Yes. We get quite a few files as 'feeds' from external systems. Once the > files are in our network, we know that no changes will happen to those files. > We access them using Oracle external tables and process them (the data, after > some processing, end up in other real tables). If external tables were not > there, we would have had to schedule some job to load these files.
I'm surprised you even need to download them to your network. I suspect it would be quite possible to implement 'external tables' so that they could be read from eg. an RSS feed. That would be a pretty slick feature. There's a gazillion number of data formats that people would want support for though; CSV, probably excel, RSS feeds, web services, etc. Most of that should probably be implemented by means of stored procedures (using the unsafe languages - pl/pythonu, pl/perlu, etc) returning TABLE (...), which means this is in fact already possible I think? It's just that nobody's (publicly) thought of doing this so far. Alban Hertroys -- Screwing up is the best way to attach something to the ceiling. !DSPAM:737,4b559f7d10601504612258! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
