Download Postgre SQL installer Download Postgre SQL https

Download Postgre. SQL installer • Download Postgre. SQL • https: //www. postgresql. org/ • https: //drive. google. com/open? id=0 B 1 Wmg. J 4 bxjje. STFq. X 3 hw. N 1 Bo. WEE 3

Download Postgre. SQL installer 4

Download Postgre. SQL installer 5

Download Postgre. SQL installer 1. 설치버전 선택 (9. 5. 9) 2. 자신의 운영체제 선택 6

Install Postgre. SQL 7

Install Postgre. SQL 8

Install Postgre. SQL 9

Install Postgre. SQL 10

Install Postgre. SQL 11

Install Postgre. SQL 12

Install Postgre. SQL 13

Install Postgre. SQL 14

Postgre. SQL – pg. Admin lll 15

Postgre. SQL – pg. Admin lll • 우클릭 -> connect 16

Postgre. SQL – create database • 우클릭 -> New Database 18

Postgre. SQL – create database DB명 입력 19

Postgre. SQL – create schema 20

Postgre. SQL – create schema Schema명 입력 21

Postgre. SQL – create table • Tables 우클릭 -> New Table 22

Postgre. SQL – create table Table 명 입력 23

Postgre. SQL – create table 1. 3. Column명 입력 (Character type 길이 입력) 2. 4. 24

Postgre. SQL – create table 25

Postgre. SQL – create table • Constraint 추가 1. 3. 26

Postgre. SQL – create table 27

Postgre. SQL – create table 28

Postgre. SQL – create table 29

Postgre. SQL – create table • 테이블 생성 완료 30

Query test • SQL editor 열기 32

Query test - result 34

Query test - quick scripts Table 우클릭 -> Scripts -> CREATE, SELECT, INSERT, UPDATE, DELETE 35

Query test - quick scripts 36