CREATE SERVER fo
   FOREIGN DATA WRAPPER postgres_fdw
  OPTIONS (host '127.0.0.1',port '5432',dbname 'olddb');
ALTER SERVER fo
  OWNER TO mainuser;
GRANT USAGE ON FOREIGN SERVER dev TO mainuser;

CREATE USER MAPPING 
   FOR mainuser
   SERVER fo
  OPTIONS (user 'mainuser',password '12345');

CREATE FOREIGN TABLE userdata
   (rowid integer ,
    username character varying(255) NOT NULL,
    password character varying(255) NOT NULL,
    type character varying(255) NOT NULL
SERVER fo
   OPTIONS (table_name 'userdata');
ALTER FOREIGN TABLE userdata
  OWNER TO mainuser;

CREATE OR REPLACE FUNCTION trtestfunction()
  RETURNS trigger AS
$BODY$
BEGIN

    -- RAISE NOTICE 'testme ';
   INSERT INTO newuserdata(uname, pass) VALUES(NEW.username, NEW.password);
    RETURN NEW;
END
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION trtestfunction()
  OWNER TO mainuser;

CREATE TRIGGER trtest
   AFTER INSERT 
   ON userdata
   FOR EACH ROW
   EXECUTE PROCEDURE trtestfunction();