Skip to content

Instantly share code, notes, and snippets.

@tyriis

tyriis/psql_db_user.sql

Last active November 2, 2018 20:47
Show Gist options
  • Save tyriis/bc77709fbf9f0f77c72e238c7767dcbc to your computer and use it in GitHub Desktop.
Save tyriis/bc77709fbf9f0f77c72e238c7767dcbc to your computer and use it in GitHub Desktop.
Download ZIP
Creating user, database and adding access on PostgreSQL
Raw
psql_db_user.sql
-- source: https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e
CREATE DATABASE yourdbname;
CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';
GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment