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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
