How to Check, Install, and Test PostgreSQL on Windows
In this tutorial, Deividas Strole shows you how to check if PostgreSQL is already installed on a Windows PC, how to install PostgreSQL, and how to test if it works from Command Prompt.
No confusion, no unnecessary add-ons — just a simple beginner-friendly PostgreSQL setup for local development.
What you'll learn:
— How to check PostgreSQL using `psql --version`
— What to do if `psql` is not recognized in CMD
— How to find the PostgreSQL installation folder
— How to test `psql.exe` using the full file path
— How to connect to PostgreSQL with `psql -U postgres`
— How to run simple SQL test commands
— How to confirm that PostgreSQL is working correctly on Windows
Perfect for beginners setting up PostgreSQL for Java, Spring Boot, backend development, full-stack projects, or local database practice.
Commands used:
`"C:\Program Files\PostgreSQL\18\bin\psql.exe" --version`
`"C:\Program Files\PostgreSQL\18\bin\psql.exe" -U postgres`
`psql --version`
`psql -U postgres`
`SELECT version();`
`SELECT 1 + 1;`
PostgreSQL is one of the most popular databases for backend development, and it is a great choice for Spring Boot, Java, and full-stack applications.
🔔 Subscribe for more beginner-friendly programming and backend development tutorials by Deividas Strole.
Tags: PostgreSQL, Windows, Command Prompt, psql, database, backend development, Java, Spring Boot, full-stack development, beginner tutorial, Deividas Strole
🔗 Connect & Learn More with Deividas Strole:
Website: https://deividasstrole.com
LinkedIn: / deividas-strole
GitHub: https://github.com/deividas-strole
Dev.to: https://dev.to/deividas-strole
Medium: / deividas-strole
X (Twitter): https://x.com/deividasstrole
🎥 Created by Deividas Strole
#PostgreSQL #Windows #SpringBoot #Java #BackendDevelopment #Database #Programming #FullStackDevelopment #DeividasStrole