SQL scripts that I use in my personal projects.
You must have installed a database in your machine.
sudo apt updatesudo apt -y upgradesudo apt install postgresql postgresql-clientThe service is automatically started upon installation, you can confirm if it is running with the command:
systemctl status postgresql.servicesudo su - postgrespsql -c "alter user postgres with password 'your_password'"createuser dbusercreatedb testdb -O dbuserpsql testdbalter user dbuser with password 'StrongPassword';\qpsql -lhttps://computingforgeeks.com/installing-postgresql-database-server-on-ubuntu/