How to get the Current Computer name or terminal name in PostgreSQL?

Question

I Need a Query of getting the Current Computer name or Terminal Name using PostgreSQL Database Please Give me the solution ASAP

What "computer name"? The hostname of the database server? Or the hostname of the client? — exhuma, Feb 22 '14 at 12:02
Hi,Here Computer name means Machine Name. Here,What I Need is, How TO Get the Query OF Current Machine Name Using PostgreSQL??? — urfrndchandu, Mar 03 '14 at 06:26

score 2 · Answer 1 · answered Feb 22 '14 at 17:23

2

Below may work for your needs. If you are on the console be careful with the results, likely you don't want to kill a postgres owned process.

SELECT inet_client_addr();


SELECT * FROM pg_stat_activity
WHERE client_addr = inet_client_addr();

answered Feb 22 '14 at 17:23

Hi, Thanks For your given Solution. But Here I am not getting the computer's name or terminal Name. – urfrndchandu Feb 25 '14 at 05:31

1 Answers1