dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

Why is there a user, what does it represent? #20

Open jay-meister opened 7 years ago

jay-meister commented 7 years ago

During the installation process, i was confused as to why a user came into it and what significance that user has. A brief explanation would be helpful.

Why do we need to create a user for our new database?

mk4111 commented 7 years ago

Could we add a line to cover the concept of 'logging in' to access the client too please?

jay-meister commented 7 years ago

Difference between a user and roles. Why would we want to create a role? Do we need to worry about it?

jay-meister commented 7 years ago

Some useful commands: