How to print server IP address (Was Re: psql prompt)

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: Los Angeles PostgreSQL Users Group <lapug(at)postgresql(dot)org>
Subject: How to print server IP address (Was Re: psql prompt)
Date: 2010-03-26 21:15:30
Message-ID: d17c5b141003261415i7ba9444bte6def12fcfb91bf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: lapug

How to print what your database server IP address and port number are:

SELECT inet_server_address(); SELECT inet_server_port();

There isn't any way to put that into the psql prompt, though.

Best,
-at

Browse lapug by date

  From Date Subject
Next Message Richard Broersma 2010-04-27 14:18:23 Up and coming LAPUG meetings
Previous Message brian dolan 2010-03-26 20:47:26 Re: psql prompt