CREATE FOREIGN TABLE ulb_ulbmsuo_oai_dc (
  id text                OPTIONS (oai_node 'identifier'),
  xmldoc xml             OPTIONS (oai_node 'content'),
  sets text[]            OPTIONS (oai_node 'setspec'),
  updatedate timestamp   OPTIONS (oai_node 'datestamp'),
  format text            OPTIONS (oai_node 'metadataprefix'),
  status boolean         OPTIONS (oai_node 'status')
 ) SERVER oai_server_ulb OPTIONS (setspec 'ulbmsuo', 
                                  metadataPrefix 'oai_dc');
SELECT * FROM ulb_ulbmsuo_oai_dc FETCH FIRST ROW ONLY;
                   id                    |                                                                                                                                             xmldoc                                                                                                                                              |              sets               |        updatedate        | format | status 
-----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------+--------------------------+--------+--------
 oai:digital.ulb.uni-muenster.de:1188818 | <oai_dc:dc xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dc="http://purl.org/dc/elements/1.1/" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/ http://www.openarchives.org/OAI/2.0/oai_dc.xsd">       +| {ulbmsuo,book,nuenning,benelux} | Wed Aug 08 07:50:15 2012 | oai_dc | f
                                         |   <dc:title>De Vryheyt Vertoont in den Staat der Vereenigde Nederlanden : Zijnde een Vertoogh van des zelfs maniere van Regeeringe, veelvondige Middelen en Oorlogs-Lasten, Met de Autentyke Stukken, zo van de Munstersche als andere Vredens Tractaten, Unie en Verbonden voorsien</dc:title>+|                                 |                          |        | 
                                         |   <dc:description>[U. E.]</dc:description>                                                                                                                                                                                                                                                     +|                                 |                          |        | 
                                         |   <dc:description>Vorlageform des Erscheinungsvermerks: By Engelbregt Boucquet, Boekverkooper ...</dc:description>                                                                                                                                                                             +|                                 |                          |        | 
                                         |   <dc:publisher>Boucquet</dc:publisher>                                                                                                                                                                                                                                                        +|                                 |                          |        | 
                                         |   <dc:publisher>Univ.- und Landesbibliothek</dc:publisher>                                                                                                                                                                                                                                     +|                                 |                          |        | 
                                         |   <dc:date>1697</dc:date>                                                                                                                                                                                                                                                                      +|                                 |                          |        | 
                                         |   <dc:type>Text</dc:type>                                                                                                                                                                                                                                                                      +|                                 |                          |        | 
                                         |   <dc:type>Book</dc:type>                                                                                                                                                                                                                                                                      +|                                 |                          |        | 
                                         |   <dc:format>[4] Bl., 400 S. ; 12-o</dc:format>                                                                                                                                                                                                                                                +|                                 |                          |        | 
                                         |   <dc:identifier>eki:HBZHT007586425</dc:identifier>                                                                                                                                                                                                                                            +|                                 |                          |        | 
                                         |   <dc:identifier>hbz-idn:CT005003895</dc:identifier>                                                                                                                                                                                                                                           +|                                 |                          |        | 
                                         |   <dc:identifier>urn:nbn:de:hbz:6-85659548630</dc:identifier>                                                                                                                                                                                                                                  +|                                 |                          |        | 
                                         |   <dc:identifier>https://nbn-resolving.org/urn:nbn:de:hbz:6-85659548630</dc:identifier>                                                                                                                                                                                                        +|                                 |                          |        | 
                                         |   <dc:identifier>system:HT007586425</dc:identifier>                                                                                                                                                                                                                                            +|                                 |                          |        | 
                                         |   <dc:relation>vignette : http://sammlungen.ulb.uni-muenster.de/titlepage/urn/urn:nbn:de:hbz:6-85659548630/128</dc:relation>                                                                                                                                                                   +|                                 |                          |        | 
                                         |   <dc:coverage>Den Haag</dc:coverage>                                                                                                                                                                                                                                                          +|                                 |                          |        | 
                                         |   <dc:rights>reserved</dc:rights>                                                                                                                                                                                                                                                              +|                                 |                          |        | 
                                         | </oai_dc:dc>                                                                                                                                                                                                                                                                                    |                                 |                          |        | 
(1 row)

CREATE FOREIGN TABLE foreign_table_without_oai_option (
  foo text
 ) SERVER oai_server_ulb OPTIONS (setspec 'ulbmsuo',
                                  metadataPrefix 'oai_dc');
                                 
SELECT * FROM foreign_table_without_oai_option;
 foo 
-----
(0 rows)

-- FOREIGN TABLE without 'oai_node' OPTION but with the 
-- mandatory SERVER OPTION nodes.
CREATE FOREIGN TABLE foreign_table_without_oai_option2 (
  foo text
 ) SERVER oai_server_ulb OPTIONS (metadataPrefix 'oai_dc');
 
SELECT * FROM foreign_table_without_oai_option2;
 foo 
-----
(0 rows)