用一个学生注册课程的实例来演示如何实现动态行列表
运行环境:PostgreSQL 9.6, psql 客户端
studentid | firstname | lastname |
---|---|---|
1 | Anne | Lee |
2 | Sarah | Christian |
3 | John | Smith |
studentid | course |
---|---|
1 | Operational System (CS501) |
1 | Compiler (CS401) |
1 | DataStructure (CS101) |
2 | Operational System (CS501) |
2 | DataStructure (CS101) |
3 | Compiler (CS401) |
3 | DataStructure (CS101) |
CREATE TABLE Students (StudentID INT PRIMARY KEY, FirstName TEXT, LastName TEXT);
INSERT INTO Students
VALUES
(1, 'Anne&