Skip to content

Instantly share code, notes, and snippets.

@blacktrub

blacktrub/psql new user and db

Last active August 14, 2018 13:25
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save blacktrub/7f6d9b24d0fc4c51032e67c15644ef9c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save blacktrub/7f6d9b24d0fc4c51032e67c15644ef9c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql new user and db
CREATE USER 'username' WITH PASSWORD 'password';
ALTER USER 'username' SUPERUSER;
CREATE DATABASE 'dbname' WITH ENCODING 'UTF8' LC_CTYPE 'en_US.UTF-8' LC_COLLATE 'en_US.UTF-8' TEMPLATE template0 OWNER 'username';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment