Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

lapug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group