| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | OpenMacNews <OpenMacNews(at)speakeasy(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: help w/ a little naive brainstorming ... |
| Date: | 2005-03-25 23:34:57 |
| Message-ID: | 20050325233456.GA69452@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 25, 2005 at 03:16:12PM -0800, OpenMacNews wrote:
> (1) does pgsql have/plan an equivalent of Oracle's External Tables?
> <http://www.oracle.com/technology/products/oracle9i/daily/sept19.html>
"The External Table feature allows for flat files, which reside
outside the database, to be accessed just like relational tables
within the database: the flat-file data can be queried and joined
to other tables using standard SQL."
You can implement this with a set-returning function that reads an
external source (flat file, spreadsheet, other kind of database,
etc.). See for example DBI-link:
http://pgfoundry.org/projects/dbi-link
With views and rules you might be able to implement update/delete
operations as well, although you wouldn't get transaction semantics.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-25 23:36:21 | Re: pg_index question |
| Previous Message | OpenMacNews | 2005-03-25 23:16:12 | help w/ a little naive brainstorming ... |