Re: [SQL] Get postgresql server ip address

2011-02-08 Thread Chris Browne
gerame...@gmail.com (Gera Mel Handumon) writes: > Is it possible to get postgresql server ip address using sql command? You can get the IP address tied to a specific connection... See the function inet_server_port(). Note, however, that the server may have a multiplicity of IP addresses, so th

Re: [SQL] Get postgresql server ip address

2011-02-08 Thread Dmitriy Igrishin
2011/2/8 Gera Mel Handumon > Hello, > > Is it possible to get postgresql server ip address using sql command? > Oh yes, use inet_server_addr() function. Please note, that NULL is returned if connection established via socket. > > TIA, > > Geramel > > > ---

[SQL] Get postgresql server ip address

2011-02-08 Thread Gera Mel Handumon
Hello, Is it possible to get postgresql server ip address using sql command? TIA, Geramel - "Share your knowledge. It's a way to achieve immortality" - Dalai Lama -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To