How to track foreign table in postgreSQL?

Question

PostgreSQL

A foreign table has been created in the postgreSQL database from another database. How can (and is it possible) to get connection parameters to an external database?
The following error occurs when attempting to access:
-----------
ERROR: connection for foreign table "tablename" cannot be authenticated
DETAIL: ORA-01017: invalid username/password; login denied
-----------
Do I understand correctly that ORA-01017 is an error from Oracle rather than postgreSQL? (which may mean that the call goes to the oracle database)

Answer 1

In psql:
\d table_name will show the name of the fdw server and the options for that particular table
\des+ fdw_server will show all information about that FDW server.
where in the system directory - run psql -E, it will print where psql itself reads data from.
Or you can do pg_dump --schema-only and look at the rebuild commands.
This is a postgresql answer
. In detail - a response from a remote database, ORA error codes - yes, oracle usually.