libname public2;

libname public1 postgres server='172.29.66.250' port=5432
   user=dbmsowner password='#6F5ZZbrkYGj8CbxDsFjifNClKReVj7X' database=VisualInvestigator schema=insider;
libname public2 postgres server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne schema=public;

data public2.address;
set public1.address;
run;
proc sql;
connect to postgres (server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne);
execute (
alter table address
add constraint address_pkey PRIMARY KEY (address_id);
)
by postgres;
disconnect from postgres;
quit;

data public2.Email_contents2;
set public1.Email_contents2;
run;
proc sql;
connect to postgres (server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne);
execute (
alter table Email_contents2
add constraint Email_contents2_pkey PRIMARY KEY (email_id);
)
by postgres;
disconnect from postgres;
quit;

data public2.Email_attachments;
set public1.Email_attachments;
run;
proc sql;
connect to postgres (server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne);
execute (
alter table Email_attachments
add constraint Email_attachments_pkey PRIMARY KEY (ema_id);
)
by postgres;
disconnect from postgres;
quit;

data public2.Employee_profile;
set public1.Employee_profile;
run;
proc sql;
connect to postgres (server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne);
execute (
alter table Employee_profile
add constraint Employee_profile_pkey PRIMARY KEY (rid);
)
by postgres;
disconnect from postgres;
quit;

data public2.phone;
set public1.phone;
run;
proc sql;
connect to postgres (server='10.38.13.127' port=5432
   user=dbmsowner password='Go4thsas' database=cyberdyne);
execute (
alter table phone
add constraint phone_pkey PRIMARY KEY (phone_id);
)
by postgres;
disconnect from postgres;
quit;