Skip to content

Instantly share code, notes, and snippets.

@zoozalp

zoozalp/create_psql_user_and_db

Last active September 17, 2017 10:34
Show Gist options
  • Save zoozalp/7bf3e47db30499593b81bbfe6ba885b8 to your computer and use it in GitHub Desktop.
Save zoozalp/7bf3e47db30499593b81bbfe6ba885b8 to your computer and use it in GitHub Desktop.
Download ZIP
Create new postgresql user and database
Raw
create_psql_user_and_db
CREATE USER <new_username> with PASSWORD '<password>';
CREATE DATABASE <new_database_name>;
GRANT ALL PRIVILEGES ON DATABASE <new_database_name> TO <new_username>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment