search

laurenz / oracle_fdw

PostgreSQL Foreign Data Wrapper for Oracle
http://laurenz.github.io/oracle_fdw/
Other
467 stars 153 forks source link

`IMPORT FOREIFN SCHEMA` new `import_views` option #656

Closed mkgrgis closed 3 months ago

mkgrgis commented 3 months ago

Hello, @laurenz ! Thanks for great FDW and interesting C code!

This is a feature request. During data migrations sometimes we need import only really stored relations, not views. Could you please implement a new option about views import (import_views?, default true) like in firebird_fdw ? Look like this can touch this place, this signature and the query from oracleGetImportColumn.

laurenz commented 3 months ago

That's a useful enhancement request. I'll leave it open; it shouldn't bee hard to implement. Perhaps I should create a TODO item...

mkgrgis commented 3 months ago

@laurenz , also there is materialized views. Users thinks this class of DB objects can have separate flag for export with default true. Generally will be useful a comment for foreign table about original object in Oracle like "This is IMPORT FOREIGN SCHEMA foreign table for table|view|materialized view". I'll try to make a draft for you.