Krettis/psql.md

## psql.md

      
    Raw
  

              psql.md
            
          
    List

\list or \l: list all databases
select database

\connect dbname or \c dbname
import

psql dbname < filepath
template1=# CREATE USER tom WITH PASSWORD 'myPassword';
Step #5: Add a database called jerry
Type the following command (you need to type command highlighted with red color):
template1=# CREATE DATABASE jerry;
Now grant all privileges on database
template1=# GRANT ALL PRIVILEGES ON DATABASE jerry to tom;