CREATE DATABASE db1;
CREATE TABLE users
(
  uid serial NOT NULL,
  name character varying(60) NOT NULL DEFAULT ''::character varying,
  pass character varying(32) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT users_pkey PRIMARY KEY (uid )
)WITH(   OIDS=FALSE );
ALTER TABLE users OWNER TO test;

CREATE DATABASE db2;
\connect db2;
CREATE extension dblink;

CREATE VIEW users AS SELECT usersxx.*
FROM dblink('hostaddr=127.0.0.1 port=5432 dbname=db1 user=test password=test'::text,
'SELECT uid, name, pass FROM users'::text)
    AS usersxx(uid integer,   name character varying(60),   pass character varying(32));

CREATE RULE users_update AS ON UPDATE TO users DO INSTEAD SELECT 
    dblink_exec('hostaddr=127.0.0.1 port=5432 dbname=db1 user=test password=test'::text,
                'UPDATE users SET name = NEW.name, pass = NEW.pass WHERE uid = NEW.uid '::text) AS dblink_exec;