CODEWITHSUNDEEP
postgresqlpostgresql-9.3
MAK
MAK

Reputation: 7260

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

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:

enter image description here

As per a_horse_with_no_name said in this answer gives me only port number.

Upvotes: 3

Views: 17868

Answers (3)

professorcolm
professorcolm

Reputation: 145

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

Upvotes: 0

Vivek S.
Vivek S.

Reputation: 21905

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

Upvotes: 8

Sathish
Sathish

Reputation: 4487

Try it for host Name

select *
from pg_settings
where name = 'listen_addresses'

Upvotes: 4

Related Questions