Database Lab

문서의 이전 판입니다!

docker run --name dbc -p 54321:5432 -e POSTGRES_PASSWORD=1234 -d postgres
docker exec -it dbc psql -U postgres
\l
CREATE DATABASE hyudb
\c hyudb

CREATE TABLE students
(
    sid    CHAR(20)            NOT NULL, 
    name   CHAR(20)    NOT NULL, 
    login  CHAR(10)    NOT NULL, 
    age    INT            NOT NULL, 
    gpa    REAL          NULL, 
    PRIMARY KEY (sid)
);

ALTER TABLE enrolled ADD PRIMARY KEY (sid, cid)

ALTER TABLE enrolled ADD FOREIGN KEY (sid) REFERENCES students;

#ALTER TABLE enrolled ADD CONSTRAINT cid_grade_unique UNIQUE (cid, grade)

\d+ students

nmap -Pnv -p 5432 ec2-54-251-188-3.ap-southeast-1.compute.amazonaws.com