1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
SET client_min_messages=NOTICE;
CREATE EXTENSION multicorn;
CREATE server multicorn_srv foreign data wrapper multicorn options (
wrapper 'multicorn.testfdw.TestForeignDataWrapper'
);
CREATE SCHEMA import_dest1;
IMPORT FOREIGN SCHEMA import_source FROM SERVER multicorn_srv INTO import_dest1;
NOTICE: IMPORT import_source FROM srv {} OPTIONS {} RESTRICTION: None []
SELECT relname FROM pg_class c INNER JOIN pg_namespace n on c.relnamespace = n.oid WHERE n.nspname = 'import_dest1' ORDER BY relname;
relname
------------------
imported_table_1
imported_table_2
imported_table_3
(3 rows)
DROP SCHEMA import_dest1 CASCADE;
NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to foreign table import_dest1.imported_table_1
drop cascades to foreign table import_dest1.imported_table_2
drop cascades to foreign table import_dest1.imported_table_3
CREATE SCHEMA import_dest1;
IMPORT FOREIGN SCHEMA import_source EXCEPT (imported_table_1, imported_table_3) FROM SERVER multicorn_srv INTO import_dest1;
NOTICE: IMPORT import_source FROM srv {} OPTIONS {} RESTRICTION: except ['imported_table_1', 'imported_table_3']
SELECT relname FROM pg_class c INNER JOIN pg_namespace n on c.relnamespace = n.oid WHERE n.nspname = 'import_dest1';
relname
------------------
imported_table_2
(1 row)
IMPORT FOREIGN SCHEMA import_source LIMIT TO (imported_table_1) FROM SERVER multicorn_srv INTO import_dest1;
NOTICE: IMPORT import_source FROM srv {} OPTIONS {} RESTRICTION: limit ['imported_table_1']
SELECT relname FROM pg_class c INNER JOIN pg_namespace n on c.relnamespace = n.oid WHERE n.nspname = 'import_dest1' ORDER BY relname;
relname
------------------
imported_table_1
imported_table_2
(2 rows)
DROP EXTENSION multicorn cascade;
NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to server multicorn_srv
drop cascades to foreign table import_dest1.imported_table_2
drop cascades to foreign table import_dest1.imported_table_1
|
