PostgreSQL client vs server

psql is a regular PostgreSQL client application . In order to connect to a database you need to know the name of your target database, the host name and port number of the server, and what user name you want to connect as.

psql is a regular PostgreSQL client application . In order to connect to a database you need to know the name of your target database, the host name and port number of the server, and what user name you want to connect as.

psql is a terminal-based front-end to PostgreSQL . It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results.