postgresql syntax

- Creating table
  ```sql
 	DROP TABLE IF EXISTS COMPANY;
	CREATE TABLE COMPANY(
	   ID INT PRIMARY KEY      NOT NULL,
	   NAME           TEXT    NOT NULL,
	   AGE            INT     NOT NULL,
	   ADDRESS        CHAR(50),
	   SALARY         REAL
	);
  ```
  For auto increment
    ```sql
	CREATE TABLE COMPANY(
	   ID SERIAL PRIMARY KEY      NOT NULL,
	   NAME           TEXT    NOT NULL,
	   AGE            INT     NOT NULL,
	   ADDRESS        CHAR(50),
	   SALARY         REAL
	);
  ```
 
  `SERIAL` for auto increment
- to load postgresql database
    
    ```bash
    psql -U postgres smart-brain
    ```
    
    Here postgres is owner name and smart-brain is name of data base. It will prompt for password which is U2FsdGVkX1/k+uOTLs4gSYVmxYAJEQybNVGnxIQVHyg=. Refer to 
    
    [Web development](../../../undefined)
    
    for decrypting it.
    
    To load postgresql without database:
    
    `psql -U postgres`
    
    To create database:
    
    `createdb mydb -U postgres`
    
    or
    
    ```bash
    psql -U postgres
    create database mydb;
    ```
    
    To get list of database:
    
    `\l`
    
    To connect to database when login as user
    
    `\connect dbname`
    
    `\q`: To quit
	- List tables, views and sequences
	  `\d`
	- Describe tables
	  `\d <table_name>`