Skip to content

Instantly share code, notes, and snippets.

@hieu-v

hieu-v/Postgresql.md

Created November 21, 2019 09:09
Show Gist options
  • Save hieu-v/a35d5dfe5010c0a9b7532aa0f6180471 to your computer and use it in GitHub Desktop.
Save hieu-v/a35d5dfe5010c0a9b7532aa0f6180471 to your computer and use it in GitHub Desktop.
Download ZIP
Some useful commands
Raw
Postgresql.md 
sudo -i -u postgres
createuser --interactive --pwprompt
createdb -O user dbname
GRANT permissions ON DATABASE dbname TO username;
dropdb ...
dropuser ...

psql -d database_name -1 -f database_name.bak
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment