Skip to content

Instantly share code, notes, and snippets.

@kishorevaishnav

kishorevaishnav/gist:eea53fe1cca20b38934c

Last active August 29, 2015 14:01
Show Gist options
  • Save kishorevaishnav/eea53fe1cca20b38934c to your computer and use it in GitHub Desktop.
Save kishorevaishnav/eea53fe1cca20b38934c to your computer and use it in GitHub Desktop.
Download ZIP
Create DB, Add User, Grant Permission. - Postgres
Raw
gistfile1.sql
--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