rachit1994

/***((((( EVERY THING IS CASE insensitive )))))****/

CREATE USER devnest WITH PASSWORD 'password';         /* Create a new user and assign password to it */
CREATE DATABASE devsDB;                               /* Create a new database, think database as drives (C:, D:) on system */
GRANT ALL PRIVILEGES ON DATABASE devsDB to devnest;   /* Gives permissions to devnest for devsDB */
DROP DATABASE IF EXISTS devsDB;                       /* Deletes the database */
CREATE DATABASE devsDB;

\l;                                                   /* lists all databases */
\c devsDB;                                            /* connects to database */