Course

In this challenge, you start by logging in with the username `pentesterlab` and the password `pentesterlab`. The main task involves accessing a PostgreSQL database using the user `postgres` who has a trivial password. After gaining access, you will use various PostgreSQL commands to explore the database. Your goal is to locate the admin account's password by listing databases, selecting one, listing its tables, and finally using the `SELECT` statement to find the necessary information.

Once you have connected to the PostgreSQL database, you can list the available databases using the `\list` command. Selecting a database is done using the `\c [DATABASE]` command, and listing the tables within the selected database is achieved using the `\d` command. The challenge concludes by using a `SELECT` statement to extract the admin password from the appropriate table. Mastering these commands will enable you to navigate and manipulate PostgreSQL databases effectively.