psql console

1. Start a Windows command console or powershell

2. Connect to PostgreSQL with

psql -U postgres

The password is CompSys2025!

1. List databases

\list

or

\l

1. Connect to database bookshop

\c bookshop

1. Display tables in database bookshop

\dt

or

\dt+

1. Show table schemas

\d tablename

1. Run your SQL statements, such as

SELECT * from books