Before using PostgreSQL, it must be installed on your computer or server. PostgreSQL runs on Windows, macOS, and Linux, making it easy to work with across different environments.
During installation, PostgreSQL creates a default user called postgres. This user has full access to the database server and is commonly used for initial setup and testing. You can interact with PostgreSQL using tools like psql (command line) or pgAdmin (graphical interface).
Once installed, confirming that PostgreSQL is running correctly is an important first step before creating databases or writing SQL queries.