psql command-line tool basics in PostgreSQL - Step-by-Step Execution

Concept Flow - psql command-line tool basics

Start psql tool

↓

Connect to database

↓

Display prompt: dbname=#

↓

Enter SQL command or psql meta-command

↓

Execute command

↓

Show results or messages

↓

Repeat or exit with \q

This flow shows how you start psql, connect to a database, enter commands, see results, and exit.

Execution Sample

PostgreSQL

\c mydb
SELECT * FROM users;
\q

Connect to 'mydb', run a query to get all users, then quit psql.

Execution Table

Step	Input	Action	Output/Result
1	\c mydb	Connect to database 'mydb'	You are now connected to database "mydb".
2	SELECT * FROM users;	Run SQL query	Displays all rows from 'users' table
3	\q	Exit psql	psql session ends, back to shell prompt

💡 User enters \q command to quit psql.

Variable Tracker

Variable	Start	After Step 1	After Step 2	After Step 3
Connected Database	none	mydb	mydb	none
Last Command	none	\c mydb	SELECT * FROM users;	\q
psql Session	not started	active	active	ended

Key Moments - 2 Insights

Why do we use a backslash before some commands like \c or \q?

Commands starting with backslash are psql meta-commands, not SQL. They control psql itself, like connecting or quitting. See execution_table rows 1 and 3.

What happens if I type a SQL command without a semicolon?

psql waits for the semicolon to know the command ended. It shows a continuation prompt until you finish the command. This is why in row 2, the query ends with a semicolon.

Visual Quiz - 3 Questions

Look at the execution table, what does the command \c mydb do?

A Runs a SQL query

B Connects to the database named 'mydb'

C Quits the psql tool

D Shows all tables

💡 Hint

Check Step 1 in the execution_table for the action and output.

At which step does the psql session end?

A Step 3

B Step 1

C Step 2

D psql never ends

💡 Hint

Look at the 'psql Session' variable in variable_tracker after each step.

If you forget the semicolon at the end of a SQL command, what will happen?

A psql executes the command immediately

B psql shows an error and exits

C psql waits for more input until semicolon is entered

D psql quits automatically

💡 Hint

Refer to key_moments about command endings and continuation prompts.

Concept Snapshot

psql is a command-line tool to interact with PostgreSQL.
Start it and connect to a database with \c dbname.
Run SQL commands ending with semicolon ;.
Use backslash commands (\q to quit).
Results show in the terminal.
Commands without semicolon wait for completion.

Full Transcript

The psql command-line tool lets you connect to PostgreSQL databases and run commands. You start psql, then connect to a database using \c followed by the database name. The prompt changes to show you are connected. You can enter SQL commands, but remember to end them with a semicolon so psql knows to run them. Some commands start with a backslash; these are special psql commands like \q to quit. When you run a command, psql shows the results or messages. You can repeat commands or exit anytime with \q.