The foreign_data_wrapper_options view contains all of the otpions defined for foreign-data wrappers in the current database. Greenplum Database displays only those foreign-data wrappers to which the current user has access (by way of being the owner or having some privilege).

    column type references description
    foreign_data_wrapper_catalog sql_identifier Name of the database in which the foreign-data wrapper is defined (always the current database).
    foreign_data_wrapper_name sql_identifier Name of the foreign-data wrapper.
    option_name sql_identifier Name of an option.
    option_value character_data Value of the option.

    Parent topic: System Catalogs Definitions