Ok, managed to get the first part working: --------------------------------------------------------------------------- create extension dblink; CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator; CREATE SERVER simfrete02 FOREIGN DATA WRAPPER postgresql OPTIONS (host '127.0.0.1', dbname 'simfrete', port '5432'); CREATE FOREIGN TABLE emp02 (ID integer NOT NULL, NOME varchar(100) NOT NULL) SERVER simfrete02; select * from usuario join emp02 on usuario.empresa_id = emp02.id; --------------------------------------------------------------------------- This error relates to the "select ..." part of the script above: ERRO: foreign-data wrapper "postgresql" has no handler ********** Error ********** ERRO: foreign-data wrapper "postgresql" has no handler SQL state: 55000 If I remove the "select ...", then the script runs without any error. What then? Thanks for your support, Edson Richter -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
