PostgreSQL 9.3: Query to get hostname,port number and username

Question

I want to write a query which should result me the following details:

1. Host,
2. Port,
3. 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.

Answer 1

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

---

System Information Functions