I want to write a query which should result me the following details:
- Host,
- Port,
- Username.
Like we get in the PgAdmin as shown in the below picture:
As per a_horse_with_no_name said in this answer gives me only port number.
3 Answers
SELECT CURRENT_USER usr
,inet_server_addr() host -- use inet_client_addr() to get address of the remote connection
,inet_server_port() port -- use inet_client_port() to get port of the remote connection
5 Comments
MAK
After running your query I get the host
::1? Does that mean localhost?MAK
The OS is window 7.
Vivek S.
@mak what is the result for
select inet_client_addr()Vivek S.
@MAK check this
select usename, client_addr from pg_catalog.pg_stat_activity;
moooeeeep
@MAK
::1 is the IPv6 version of localhost: en.wikipedia.org/wiki/LocalhostTry it for host Name
select *
from pg_settings
where name = 'listen_addresses'
Building on w͏̢in̡͢g͘̕ed̨p̢͟a͞n͏͏t̡͜͝he̸r̴'s answer above;
SELECT CURRENT_USER usr, :'HOST' host, inet_server_port() port;
This uses psql's built in HOST variable, documented here
1 Comment
EM0
An interesting approach, but worth noting: this only works in the
psql tool, not using other clients, and for a Unix socket connection it returns the socket path.
SELECT * FROM pg_settingsshow you?