PostgreSQL query to find the host name

subhash-DBA 105

HI Team,

I am looking for a PostgreSQL command/query (not Azure CLI )that i can run in Azure PostgreSQL flexible server to get the server name.

currently i can get this info using the below psql command "\conninfo", but this command works only in the PSQL prompt and not part of stored procedures/code that runs from applications.

NIKHILA NETHIKUNTA 4,020 Reputation points Microsoft Vendor

2025-01-10T07:17:10.15+00:00

@subhash-DBA
Thank you for the question and for using Microsoft Q&A platform.

As per my understanding you are trying to get the Postgre SQL server's name using a query.
Can you please let me know what application are you trying to run? This would help me to understand the query better.

The above queries are used to fetch the database name, server's IP address and port number, which can help identify the server and also the version of the server. Hope this helps.
NIKHILA NETHIKUNTA 4,020 Reputation points Microsoft Vendor

2025-01-13T09:02:50.3566667+00:00

@subhash-DBA
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
subhash-DBA 105 Reputation points

2025-01-13T22:40:09.81+00:00

HI Nikhila,

I am using PGAdmin (version 8.2) to develop a stored proc which will get the server name from a sql query which i use for further logic in the stored proc.

The query you posted gives me IP address/ port but that's not I am looking for

Share via

PostgreSQL query to find the host name

Your answer