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,100 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
NIKHILA NETHIKUNTA 4,100 Reputation points Microsoft Vendor

2025-01-15T07:02:54.05+00:00

@subhash-DBA
You can try to use RestAPI with sp_invoke_external_rest_endpoint to get server name in the stored procedure. The sp_invoke_external_rest_endpoint stored procedure invokes an HTTPS REST endpoint provided as an input argument to the procedure.

You can refer to the below documents:

https://learn.microsoft.com/en-us/rest/api/postgresql/singleserver/servers/get?view=rest-postgresql-singleserver-2017-12-01&tabs=HTTP
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-invoke-external-rest-endpoint-transact-sql?view=fabric&tabs=request-headers

Hope this helps. Please let us know if you have any further questions.
NIKHILA NETHIKUNTA 4,100 Reputation points Microsoft Vendor

2025-01-16T06:46:16.2066667+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.

1 answer

NIKHILA NETHIKUNTA 4,100 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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

PostgreSQL query to find the host name

1 answer

Your answer