dn8b9aid

1CREATE EXTENSION if not exists postgres_fdw;
2
3CREATE SERVER if not exists server_name 
4	FOREIGN DATA WRAPPER postgres_fdw 
5	OPTIONS (host '10.74.30.137', port '5432', dbname 'postgres');
6
7CREATE USER MAPPING IF NOT exists FOR db_user 
8	SERVER server_name 
9	OPTIONS (user 'postgres', password 'password');
10	
11
12CREATE FOREIGN TABLE if not exists arch_doze (
13 				"UUP_Code"      INTEGER,
14	            "Code"          FLOAT,
15	            "Silo"          FLOAT,
16	            "Mine"          VARCHAR(40),
17	            "Mark"          VARCHAR(8),
18	            "Percents"      FLOAT,
19	            "PercReal"      FLOAT,
20	            "Product"       FLOAT NULL,
21	            "TimeBegin"     VARCHAR(8) NULL,
22	            "TimeEnd"       VARCHAR(8) NULL,
23	            "Number_layer"  FLOAT,
24	            "Shift"         FLOAT,
25	            "Data"          TIMESTAMP WITH TIME ZONE,
26	            "W"             FLOAT,
27	            "A"             FLOAT,
28	            "V"             FLOAT,
29	            "X"             FLOAT,
30	            "Y"             FLOAT,
31	            "P"             FLOAT,
32	            "S"             FLOAT,
33	            "NAKLADN"       FLOAT,
34	            "MSDtimeS"      TIMESTAMP WITH TIME zone,
35	            "SULFUR"        FLOAT,
36	            "SECTION"       INTEGER NULL,
37	            "SHIFTNUMBER"   INTEGER ,
38	            "R_NULL"        FLOAT,
39	            "VT"            FLOAT,
40	            "SUMM_OK"       FLOAT,
41	            "SIGMA_R"       FLOAT,
42	            "CONSAMER"      INTEGER,
43	            "N_PROB"        INTEGER,
44	            "ADD_DTTM"      TIMESTAMP WITH TIME zone NULL,
45	            "LAST_UPD_DTTM" TIMESTAMP WITH TIME zone NULL
46	    )
47
48SERVER server_name;