I m getting some problem while using postgres_fdw.
CREATE SERVER foreign_server FOREIGN DATA WRAPPER postgres_fdw OPTIONS (host '18.104.22.168', port '5432', dbname 'Test'); CREATE USER MAPPING FOR postgres SERVER foreign_server OPTIONS (user 'foreign_user', password 'password'); CREATE FOREIGN TABLE foreign_table ( id serial NOT NULL, data text)SERVER foreign_server OPTIONS (schema_name 'public', table_name 'employee'); select * from employee where user ='foreign_user'
Now I can see entries are made to
But How do I access employee table of remote system.
select * from employee where user ='foreign_user' doesn't give any result.Though it has data in Employee table of remote system.
please do help