SELECT p.* from dblink('host=localhost user=postgresuser password=postgrespassword dbname=mydb', 'select code_type from my.common_code') AS p(code_type varchar(10))