-- 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': 10 SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema'; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+--------------------+------------------------+--------------------- contrib_regression | ulb_schema | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshs | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmssp | 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 | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsh | contrib_regression | oai_server_ulb (10 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'; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+---------------------------+------------------------+--------------------- contrib_regression | ulb_schema | ulbmshbw | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshs | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmssp | 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 | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | ulbmsh | contrib_regression | oai_server_ulb contrib_regression | ulb_schema | oai_server_ulb_repository | contrib_regression | oai_server_ulb (11 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'; 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': 8 SELECT * FROM information_schema.foreign_tables WHERE foreign_table_schema = 'ulb_schema2'; 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 contrib_regression | ulb_schema2 | ulbmssp | 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 | ulbmsum | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsob | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | nachlass_scholz | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmshd | contrib_regression | oai_server_ulb contrib_regression | ulb_schema2 | ulbmsh | contrib_regression | oai_server_ulb (10 rows) -- Importing schema 'oai_sets' (DNB) CREATE SCHEMA dnb_schema; IMPORT FOREIGN SCHEMA oai_sets FROM SERVER oai_server_dnb INTO dnb_schema OPTIONS (metadataprefix 'MARC21-xml'); NOTICE: Foreign tables to be created in schema 'dnb_schema': 5294 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 +| | | | | +| | | | | +| | | | | 42022 +| | | | | +| | | | | +| | | | | 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)