Re: help w/ a little naive brainstorming ...
От | OpenMacNews |
---|---|
Тема | Re: help w/ a little naive brainstorming ... |
Дата | |
Msg-id | A69027BFA4C97540EDAA97BA@tiedgar обсуждение исходный текст |
Ответ на | Re: help w/ a little naive brainstorming ... (Michael Fuhr <mike@fuhr.org>) |
Список | 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
В списке pgsql-general по дате отправления: