Thread: Create foreign table documentation
Hi admins
Dealing with extension oracle_fdw there are a couple of objects need to create SERVER, FOREIGN DATA WRAPPER , USER MAPPING , FOREIGN TABLE, all having clause OPTIONS ( option 'value' [, ...] ), but I can't find any documentation about it, which are the specific options allowed for option 'value' in each instruction....:
Thank you very much in advance
kind regards
Mauricio Fernández
Am 03.04.25 um 15:09 schrieb Mauricio Fernandez: > Hi admins > > Dealing with extension oracle_fdw there are a couple of objects need > to create SERVER, FOREIGN DATA WRAPPER , USER MAPPING , FOREIGN TABLE, > all having clause OPTIONS ( option 'value' [, ...] ), but I can't find > any documentation about it, which are the specific options allowed for > option 'value' in each instruction....: > > Thank you very much in advance > > kind regards > > Mauricio Fernández These options depend on the specific FDW, so you have to look them up in their description. -- Holger Jakobs
Thank you very much Holger, you were right...
The documentation from oacle_fwd is explicit: https://github.com/laurenz/oracle_fdw?tab=readme-ov-file#3-options
kind regards
Mauricio Fernández
El jue, 3 abr 2025 a las 10:15, Holger Jakobs (<holger@jakobs.com>) escribió:
Am 03.04.25 um 15:09 schrieb Mauricio Fernandez:
> Hi admins
>
> Dealing with extension oracle_fdw there are a couple of objects need
> to create SERVER, FOREIGN DATA WRAPPER , USER MAPPING , FOREIGN TABLE,
> all having clause OPTIONS ( option 'value' [, ...] ), but I can't find
> any documentation about it, which are the specific options allowed for
> option 'value' in each instruction....:
>
> Thank you very much in advance
>
> kind regards
>
> Mauricio Fernández
These options depend on the specific FDW, so you have to look them up in
their description.
--
Holger Jakobs