how to know machine name and program name in postgresql?

Question

select secure_decrypt_log_id_seq.nextval,**v.PROGRAM**, 
'CONTRACT_PAYMENT_ID = '||to_Char(:new.CONTRACT_PAYMENT_ID), sysdate, user, **v.MACHINE**, ls_transaction_type
from v$session v
where v.sid =  (select sid from **v$mystat** where rownum = 1)

I am not able to find equivalent functions in PostgreSQL. The above code is of oracle and I cannot find any proper references to Program, Machine & mystat. AWS-SCT cannot find similar functions in Postgres

score 1 · Answer 1 · answered Nov 03 '20 at 11:26

You can have the client address: client_addr in pg_stat_activity (or client_hostname if you have enabled log_hostname).

There is no way to access the name of the client executable on the server, as such information is not reliable, but my recommendation is that the client sets the application_name parameter and the server fetches it from pg_stat_activity.

how to know machine name and program name in postgresql?

1 Answers1