Cacher is the code snippet organizer for pro developers

How To Install and Use PostgreSQL on Ubuntu 16.04
Link:
https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04

How To Setup Ruby on Rails with Postgres
Link:
https://www.digitalocean.com/community/tutorials/how-to-setup-ruby-on-rails-with-postgres


PostgreSQL Tutorial
Link:
http://www.postgresqltutorial.com

Setup Ruby On Rails on Ubuntu 16.04 Xenial Xerus | Postgresql
Link:
https://gorails.com/setup/ubuntu/16.04#postgresql


How to change your Rails app database from SQLite to PostgreSQL before deploying to Heroku! — Medium
Link:
https://medium.com/@helenflam/how-to-change-your-rails-app-database-from-sqlite-to-postgresql-before-deploying-to-heroku-ae2acc25c7ac#.85q93shed


How to List Databases and Tables in PostgreSQL Using psql
Link:
https://chartio.com/resources/tutorials/how-to-list-databases-and-tables-in-postgresql-using-psql/





sudo -i -u postgres
psql
CREATE USER nameapplication SUPERUSER INHERIT CREATEDB CREATEROLE;
ALTER USER nameapplication with password 'passwordapplication';
\q