Download Postgre SQL installer Download Postgre SQL https Slides: 33 Download presentation 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 • 테이블 생성 완료 26 Query test • SQL editor 열기 28 Query test - result 30 Query test - quick scripts Table 우클릭 -> Scripts -> CREATE, SELECT, INSERT, UPDATE, DELETE 31 Query test - quick scripts 32