-- Münster University Library CREATE SERVER oai_server_ulb FOREIGN DATA WRAPPER oai_fdw OPTIONS (url 'https://sammlungen.ulb.uni-muenster.de/oai', request_redirect 'true'); -- Importing schema 'oai_sets' CREATE SCHEMA ulb_schema; IMPORT FOREIGN SCHEMA oai_sets FROM SERVER oai_server_ulb INTO ulb_schema OPTIONS (metadataprefix 'oai_dc'); NOTICE: Foreign tables to be created in schema 'ulb_schema': 37 SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema' ORDER BY foreign_table_name COLLATE "C"; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+-----------------------+------------------------+--------------------- contrib_regression | ulb_schema | benelux | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | busch | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | collectioerhard | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | collection9536440 | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fremdbestand_hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fuerstenau | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fuerstenbergstammheim | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | haindorf | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | haxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | jesuiten | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | kartenhaxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | lstierlin | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | mnordkirchen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | mromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nlflugschrift | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nuenning | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sDroste | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sbibelmuseum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | schoepper | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | schreiber | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sscholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | stoecker | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | stramm | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsh | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshs | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsretro | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmssp | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsuo | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | wappenkalender | contrib_regression | oai_server_ulb (37 rows) -- Importing schema 'oai_repository' IMPORT FOREIGN SCHEMA oai_repository FROM SERVER oai_server_ulb INTO ulb_schema OPTIONS (metadataprefix 'oai_dc'); SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema' ORDER BY foreign_table_name COLLATE "C"; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+---------------------------+------------------------+--------------------- contrib_regression | ulb_schema | benelux | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | busch | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | collectioerhard | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | collection9536440 | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fremdbestand_hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fuerstenau | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | fuerstenbergstammheim | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | haindorf | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | haxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | jesuiten | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | kartenhaxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | lstierlin | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | mnordkirchen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | mromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nlflugschrift | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nuenning | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | oai_server_ulb_repository | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sDroste | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sbibelmuseum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | schoepper | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | schreiber | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | sscholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | stoecker | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | stramm | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsh | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshs | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsretro | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmssp | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsuo | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | wappenkalender | contrib_regression | oai_server_ulb (38 rows) -- Import schema 'oai_sets' LIMIT TO CREATE SCHEMA ulb_schema2; IMPORT FOREIGN SCHEMA oai_sets LIMIT TO (ulbmshbw,ulbmshs) FROM SERVER oai_server_ulb INTO ulb_schema2 OPTIONS (metadataprefix 'oai_dc'); NOTICE: Foreign tables to be created in schema 'ulb_schema2': 2 SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema2' ORDER BY foreign_table_name COLLATE "C"; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+--------------------+------------------------+--------------------- contrib_regression | ulb_schema2 | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmshs | contrib_regression | oai_server_ulb (2 rows) -- Import schema 'oai_sets' EXCEPT IMPORT FOREIGN SCHEMA oai_sets EXCEPT (ulbmshbw,ulbmshs) FROM SERVER oai_server_ulb INTO ulb_schema2 OPTIONS (metadataprefix 'oai_dc'); NOTICE: Foreign tables to be created in schema 'ulb_schema2': 35 SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema2' ORDER BY foreign_table_name COLLATE "C"; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+-----------------------+------------------------+--------------------- contrib_regression | ulb_schema2 | benelux | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | busch | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | collectioerhard | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | collection9536440 | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | fremdbestand_hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | fuerstenau | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | fuerstenbergstammheim | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | haindorf | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | haxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | hbz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | jesuiten | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | kartenhaxthausen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | lstierlin | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | mnordkirchen | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | mromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | nlflugschrift | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | nuenning | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | sDroste | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | sbibelmuseum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | schoepper | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | schreiber | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | sromberg | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | sscholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | stoecker | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | stramm | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsh | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmshs | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsretro | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmssp | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsuo | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | wappenkalender | contrib_regression | oai_server_ulb (37 rows) -- Importing schema 'oai_sets' (DNB) CREATE SERVER oai_server_dnb FOREIGN DATA WRAPPER oai_fdw OPTIONS (url 'https://services.dnb.de/oai/repository', request_redirect 'true', request_max_redirect '1'); CREATE USER MAPPING FOR postgres SERVER oai_server_dnb OPTIONS (user 'foo', password 'bar', proxy_user 'foo', proxy_password 'bar'); CREATE SCHEMA dnb_schema; IMPORT FOREIGN SCHEMA oai_sets LIMIT TO ("dnb:reiheC") FROM SERVER oai_server_dnb INTO dnb_schema OPTIONS (metadataprefix 'MARC21-xml'); NOTICE: Foreign tables to be created in schema 'dnb_schema': 1 SELECT * FROM dnb_schema."dnb:reiheC" WHERE id = 'oai:dnb.de/dnb:reiheC/1253187622'; id | xmldoc | sets | updatedate | format | status ----------------------------------+----------------------------------------------------------------------------------------------+--------------+--------------------------+------------+-------- oai:dnb.de/dnb:reiheC/1253187622 | +| {dnb:reiheC} | Wed Jul 06 20:40:38 2022 | MARC21-xml | f | 00000nem a2200000 cb4500 +| | | | | 1253187622 +| | | | | DE-101 +| | | | | 20220706224038.0 +| | | | | a||||||| +| | | | | 220309s2022 gw |||||||a|| ||||ger +| | | | | +| | | | | 22,C02 +| | | | | dnb +| | | | | +| | | | | +| | | | | DE-101 +| | | | | 1253187622 +| | | | | +| | | | | +| | | | | keine Bindung +| | | | | +| | | | | +| | | | | a +| | | | | E 010 24 56 +| | | | | E 010 29 55 +| | | | | N 050 41 56 +| | | | | N 050 38 56 +| | | | | A:agx +| | | | | +| | | | | +| | | | | a +| | | | | E010.415555 +| | | | | E010.498611 +| | | | | N050.698888 +| | | | | N050.648888 +| | | | | A:dgx +| | | | | +| | | | | +| | | | | (DE-599)DNB1253187622 +| | | | | +| | | | | +| | | | | (OCoLC)1334593450 +| | | | | +| | | | | +| | | | | 1180 +| | | | | ger +| | | | | DE-101 +| | | | | 9999 +| | | | | rda +| | | | | +| | | | | +| | | | | ger +| | | | | +| | | | | +| | | | | XA-DE +| | | | | +| | | | | +| | | | | 2\p +| | | | | 910 +| | | | | 914.3 +| | | | | DE-101 +| | | | | 23sdnb +| | | | | +| | | | | +| | | | | 1\p +| | | | | (DE-588)118040811X +| | | | | https://d-nb.info/gnd/118040811X +| | | | | (DE-101)118040811X +| | | | | Thüringer Landesamt für Bodenmanagement und Geoinformation+| | | | | Kartograf +| | | | | ctg +| | | | | gnd +| | | | | +| | | | | +| | | | | Schmalkalden-Grumbach +| | | | | +| | | | | +| | | | | Ausgabe 2022 +| | | | | +| | | | | +| | | | | 1:10 000 +| | | | | +| | | | | +| | | | | Erfurt +| | | | | Landesamt für Bodenmanagement und Geoinformation +| | | | | [2022] +| | | | | +| | | | | +| | | | | 1 Karte +| | | | | 56 x 59 cm, auf Blatt 60 x 76 cm +| | | | | +| | | | | +| | | | | kartografisches Bild +| | | | | cri +| | | | | rdacontent +| | | | | +| | | | | +| | | | | ohne Hilfsmittel zu benutzen +| | | | | n +| | | | | rdamedia +| | | | | +| | | | | +| | | | | Blatt +| | | | | nb +| | | | | rdacarrier +| | | | | +| | | | | +| | | | | Topographische Karte 1:10 000 +| | | | | 5328-NO +| | | | | +| | | | | +| | | | | (DE-588)4133697-5 +| | | | | https://d-nb.info/gnd/4133697-5 +| | | | | (DE-101)041336976 +| | | | | Topografie +| | | | | rswk-swf +| | | | | gnd +| | | | | +| | | | | +| | | | | (DE-588)1063313759 +| | | | | https://d-nb.info/gnd/1063313759 +| | | | | (DE-101)1063313759 +| | | | | Schmalkalden-Grumbach +| | | | | rswk-swf +| | | | | gnd +| | | | | +| | | | | +| | | | | (DE-588)1063310814 +| | | | | https://d-nb.info/gnd/1063310814 +| | | | | (DE-101)1063310814 +| | | | | Schmalkalden-Breitenbach +| | | | | rswk-swf +| | | | | gnd +| | | | | +| | | | | +| | | | | (DE-588)7596251-2 +| | | | | https://d-nb.info/gnd/7596251-2 +| | | | | (DE-101)987079514 +| | | | | Christes +| | | | | rswk-swf +| | | | | gnd +| | | | | +| | | | | +| | | | | (DE-588)4029783-4 +| | | | | https://d-nb.info/gnd/4029783-4 +| | | | | (DE-101)040297837 +| | | | | Karte +| | | | | gnd-content +| | | | | +| | | | | +| | | | | (DE-588)1063313759 +| | | | | https://d-nb.info/gnd/1063313759 +| | | | | (DE-101)1063313759 +| | | | | g +| | | | | Schmalkalden-Grumbach +| | | | | +| | | | | +| | | | | (DE-588)1063310814 +| | | | | https://d-nb.info/gnd/1063310814 +| | | | | (DE-101)1063310814 +| | | | | g +| | | | | Schmalkalden-Breitenbach +| | | | | +| | | | | +| | | | | (DE-588)7596251-2 +| | | | | https://d-nb.info/gnd/7596251-2 +| | | | | (DE-101)987079514 +| | | | | g +| | | | | Christes +| | | | | +| | | | | +| | | | | (DE-588)4133697-5 +| | | | | https://d-nb.info/gnd/4133697-5 +| | | | | (DE-101)041336976 +| | | | | s +| | | | | Topografie +| | | | | +| | | | | +| | | | | DE-101 +| | | | | DE-101 +| | | | | +| | | | | +| | | | | Thüringer Landesamt für Bodenmanagement und Geoinformation+| | | | | aut +| | | | | Topographische Karte 1:10 000 +| | | | | 5328-NO +| | | | | (DE-101)1182592287 +| | | | | 45328 no +| | | | | em +| | | | | +| | | | | +| | | | | DE-101a +| | | | | DE-101b +| | | | | +| | | | | +| | | | | 1\p +| | | | | dnb +| | | | | 20220329 +| | | | | DE-101 +| | | | | https://d-nb.info/provenance/plan#dnb +| | | | | +| | | | | +| | | | | 2\p +| | | | | dnb +| | | | | 20220412 +| | | | | DE-101 +| | | | | https://d-nb.info/provenance/plan#dnb +| | | | | +| | | | | +| | | | | rc +| | | | | +| | | | | | | | | (1 row) \set VERBOSITY terse DROP SERVER IF EXISTS oai_server_dnb CASCADE; NOTICE: drop cascades to 2 other objects