문서의 이전 판입니다!
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