Hello,
I’m using dblink package to execute queries between two postgresql databases. Access definitions for the dblink are created using foreign data wrapper, server and user mappings. When I set user and password as options then postgres saves these parameters in four system tables (table pg_user_mapping, view pg_user_mappings, information_schema: _pg_user_mapping and user_mapping_options) and all these tables store un-encrypted password. Is there a way to create user mappings using encrypted passwords or store the password encrypted in system tables? Thanks, Sergey
