| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgres external table |
| Date: | 2010-01-19 12:03:06 |
| Message-ID: | B90377CB-49F5-4DC2-959D-9D080861DB4D@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jayadevan M | 2010-01-19 12:13:32 | Re: postgres external table |
| Previous Message | Sam Mason | 2010-01-19 11:54:33 | Re: Index on immutable function call |