how can i get machine name in postgresql

123ilsql

New Member

Join Date: Nov 2020

Posts: 1
#1

how can i get machine name in postgresql

Nov 3 '20, 11:41 AM

Want to know the command for getting program name and machine name used for postgre script after aws sct conversion from oracle to postgresql.
Tags: None
SioSio

Contributor

Join Date: Dec 2019

Posts: 272
#2

Nov 5 '20, 12:44 AM

The pg_gethostname( ) function (a wrapper for POSIX gethostname()) written in C has been contributed to the wiki and is now available as an extension to PGXN.

Pg gethostname - PostgreSQL wiki

https://wiki.postgresql.org/wiki/Pg_gethostname
Comment

Comment