티스토리 뷰
select dblink_connect('dbbasic', 'hostaddr=127.0.0.1 port=5432 dbname=IMC_MOCA_20160610 user=postgres password=@yudo.com');
/*
INSERT INTO ts_machine
(
mc_id,
mc_nm,
model,
line,
ton,
mold_id,
use_yn,
in_date,
in_user,
up_date,
up_user,
seq,
total_count,
reg_date,
date_index
)
SELECT * FROM
dblink('dbbasic',
'select
mc_id,
mc_nm,
model,
line,
ton,
mold_id,
use_yn,
in_date,
in_user,
up_date,
up_user,
seq,
total_count,
reg_date,
date_index
from ts_machine') AS t1
(
mc_id varchar,
mc_nm varchar,
model varchar,
line varchar,
ton integer,
mold_id varchar,
use_yn varchar,
in_date timestamp,
in_user varchar,
up_date timestamp,
up_user varchar,
seq bigint,
total_count integer,
reg_date timestamp,
date_index varchar
);
*/
/*
insert into ts_device_mapping
(
dgs_id,
context_id,
slave_id,
virtual_id,
mc_id,
device_type,
device_type_name,
mapping_key
)
SELECT * FROM
dblink('dbbasic',
'select
dgs_id,
context_id,
slave_id,
virtual_id,
mc_id,
device_type,
device_type_name,
mapping_key
from ts_device_mapping') AS t1
(
dgs_id varchar,
context_id varchar,
slave_id varchar,
virtual_id varchar,
mc_id varchar,
device_type varchar,
device_type_name varchar,
mapping_key bigint
);
*/
/*
insert into ts_line
(
line_no,
line_nm,
seq,
visible_yn,
in_date,
in_user,
up_date,
up_user
)
SELECT * FROM
dblink('dbbasic',
'select
line_no,
line_nm,
seq,
visible_yn,
in_date,
in_user,
up_date,
up_user
from ts_line') AS t1
(
line_no varchar,
line_nm varchar,
seq integer,
visible_yn varchar,
in_date timestamp,
in_user varchar,
up_date timestamp,
up_user varchar
);
*/
/*
insert into ts_mold_info
(
mold_id,
mold_nm,
prod_nm,
cavity,
cycle_time,
resin,
prod_weight,
screw_weight,
ton,
maker,
use_yn,
in_date,
in_user,
up_date,
up_user,
del_yn
)
SELECT * FROM
dblink('dbbasic',
'select
mold_id,
mold_nm,
prod_nm,
cavity,
cycle_time,
resin,
prod_weight,
screw_weight,
ton,
maker,
use_yn,
in_date,
in_user,
up_date,
up_user,
del_yn
from ts_mold_info') AS t1
(
mold_id varchar,
mold_nm varchar,
prod_nm varchar,
cavity integer,
cycle_time integer,
resin varchar,
prod_weight integer,
screw_weight integer,
ton integer,
maker varchar,
use_yn varchar,
in_date timestamp,
in_user varchar,
up_date timestamp,
up_user varchar,
del_yn varchar
)
*/
select dblink_disconnect('dbbasic');
'postgresql' 카테고리의 다른 글
postgres 비밀번호 변경 버그??? (0) | 2017.10.21 |
---|---|
PostgreSQL에서 MySQL의 AUTO_INCREMENT와 같은 자동증가 컬럼 (0) | 2017.10.21 |