sql.md

Steps for Creating Database

• Download the zipfile
• Open and extract the .tar file use iZip
• Open pgAdmin3 in the terminal $ pgadmin3
• Double click on PGSQL9.5 to see the database drop down
• Right click on Databases and select "New Database"
• Name the database and select done

Creating a Database

In pgAdmin3 there are a few different ways to create a database

One way in pgAdmin3:

• Right click on Databases
• Select New Database
• Name it
• Click OK

Another way in pgAdmin3:

• Click Postgres
• THen click SQL in the toolbar which brings up a SQL editor
• In that editor type in: CREATE DATABASE nameofdatabase;
• Click the green arrow to run/execute the query
• You'll see in the output section "Query returned successfully with no result in 658 ms."

Deleting a Database

• Right click on the database you want to delete and select Delete/Drop