Listing general PostgreSQL commands here for my future self.
Start
This is the command I’m using to check if the psql
running locally.
/etc/init.d/postgresql status
service postgresql status
Note: I’m using MacOS
Status
To check the status of the postgres services in your machine use this below command.
psql postgres
Create
User
Always create user when you’re working with PostgreSQL instance. It’s okay to create just database and use but using the username and password in the DATABASE_URL
is the recommended way.
CREATE USER rajasimon with PASSWORD 'password';
Replace password with your user password.
Database
Creating database is easy with single line comment.
create database dbname
Permission
Assigning permission is really important if you’re working with user and database together.
GRANT ALL PRIVILEGES ON DATABASE "dbname" to rajasimon;
Password
TO change the password please use this command.
\password <password>
Connect
To use the database we must connect with it.
\connect webaccount
I’ve also created the gist for quick glance incase if you want to check my original source.