setup PostgresSQL database

gistfile1.txt

# Access PostgreSQL: Once PostgreSQL is installed, you can access it using the command-line tool psql.
# Open your terminal or command prompt and run:
psql -U postgres

# Create a Database: To create a new database, you can use the following SQL command inside the psql prompt:
CREATE DATABASE yourdbname;

# Create a User with a Password: You can create a new user and set a password for that user using the following SQL commands:
CREATE USER yourusername WITH PASSWORD 'yourpassword';

# Grant Privileges: To allow the new user to access and manage the database you created, 
# you can grant them privileges using the following SQL command:
GRANT ALL PRIVILEGES ON DATABASE "yourdbname" TO "yourusername";