Start using PostgreSQL

Connect with psql

Open a PostgreSQL command-line session and identify the server, database, and role used by the connection.

8 minute lesson

~~~

Start with the maintenance database that PostgreSQL creates:

psql postgres

Inside psql, inspect the real connection:

\conninfo
SELECT version();

A complete connection can specify a host, port, role, and database. The psql client is not the server. It is one program that talks to it.

Lesson completed

Take this course offline

Get every free book and course as PDF and EPUB files.

Get the download library →