Find the host name and port using PSQL commands

postgresql psql
jamesatha picture jamesatha · Apr 8, 2011 · Viewed 312.6k times · Source

I have PSQL running, and am trying to get a perl application connecting to the database. Is there a command to find the current port and host that the database is running on?

Answer

a_horse_with_no_name picture a_horse_with_no_name · Apr 8, 2011 
SELECT *
FROM pg_settings
WHERE name = 'port';

Related questions

PostgreSQL "DESCRIBE TABLE"

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Read More
Run a PostgreSQL .sql file using command line arguments

I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …

Read More
How to switch databases in psql?

In MySQL, I used use database_name; What's the psql equivalent?

Read More