Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Create DB, Add User, Grant Permission. - Postgres
--To Create the database & add user to that
CREATE DATABASE <dbname>;
CREATE USER <username>;
\password <username>
GRANT ALL PRIVILEGES ON DATABASE <dbname> TO <username>;
ALTER DATABASE <dbname> OWNER TO <username>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment