From: | OpenMacNews <OpenMacNews(at)speakeasy(dot)net> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Cc: | Michael Fuhr <mike(at)fuhr(dot)org> |
Subject: | Re: help w/ a little naive brainstorming ... |
Date: | 2005-03-25 23:40:23 |
Message-ID: | A69027BFA4C97540EDAA97BA@tiedgar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi michael,
>> (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
cool. great place to start learning ...
> With views and rules you might be able to implement update/delete
> operations as well, although you wouldn't get transaction semantics.
baby steps for me. i'd be happy 4 now with update/delete ... and worry abt the
rest as needed later ...
thx!
richard
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Lee Tucker | 2005-03-26 00:26:09 | Re: pg_index question |
Previous Message | Tom Lane | 2005-03-25 23:36:21 | Re: pg_index question |