postgres_fdw: Extend postgres_fdw_get_connections to return user name.
authorFujii Masao <fujii@postgresql.org>
Wed, 18 Sep 2024 03:51:48 +0000 (12:51 +0900)
committerFujii Masao <fujii@postgresql.org>
Wed, 18 Sep 2024 03:51:48 +0000 (12:51 +0900)
commit4f08ab55457751308ffd8d33e82155758cd0e304
tree5fd7cac9932bb064c44becfd09870a0cdfb523f1
parentb14e9ce7d55c75ffa160b07765eb9dffde70b5fa
postgres_fdw: Extend postgres_fdw_get_connections to return user name.

This commit adds a "user_name" output column to
the postgres_fdw_get_connections function, returning the name
of the local user mapped to the foreign server for each connection.
If a public mapping is used, it returns "public."

This helps identify postgres_fdw connections more easily,
such as determining which connections are invalid, closed,
or used within the current transaction.

No extension version bump is needed, as commit c297a47c5f
already handled it for v18~.

Author: Hayato Kuroda
Reviewed-by: Fujii Masao
Discussion: https://postgr.es/m/b492a935-6c7e-8c08-e485-3c1d64d7d10f@oss.nttdata.com
contrib/postgres_fdw/connection.c
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/postgres_fdw--1.1--1.2.sql
contrib/postgres_fdw/sql/postgres_fdw.sql
doc/src/sgml/postgres-fdw.sgml