DEV Community

loading...

Creating a Postgres database + user

connorbode profile image Connor Bode ・1 min read

Let's create a new database + a user to access it.

  1. su - postgres to get a shell as the postgres user
  2. psql to get a postgres shell
  3. create database db_name; to create the database
  4. create user user_name with encrypted password 'user_password'; to create the user
  5. grant all privileges on database db_name to user_name; to grant the user all privileges on the database.

That's it really.


As a brief aside, I like to write my SQL in all lowercase. I find it really annoying to use all caps for statements and all lowercase for variables, which seems to be a syntactic standard with no real benefit? Anyone else do this / have a comment on this?


Follow me on dev.to for more code blurbs, or on Twitter @connorbode

Discussion

pic
Editor guide