SELECT *
FROM dblink('dbname=dummydb port=5432 host=localhost user=postgres password=dummy', 'SELECT id , name FROM users') AS users_in_other_db (
  id integer,
  name varchar(255)
);