Write-up author: jon-brandy
Connect to this PostgreSQL server and find the flag!
psql -h saturn.picoctf.net -p 64980 -U postgres pico
Password is postgres
- SQL command to check database inside.
- First, launch the machine to get the PostgreSQL server.
- Then i got this
psql -h saturn.picoctf.net -p 64980 -U postgres pico. So i run the command at my kali linux terminal. - Enter the password as
postgres.
- Next, based from the hint, in PostgreSQL if you run this command
\dtit will lists all tables in PostgreSQL.
- It is known, there is a table named flags. So let's try to see what's inside by run this command
SELECT * FROM flags;.
- But somehow it is not working, now let's change all the letters to lowercase ->
select * from flags;.
- Finally, we got the flag!
picoCTF{L3arN_S0m3_5qL_t0d4Y_21c94904}