students-postgresql.sql

--全部字段和表名用小写

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10001', '刘备', 'm', 40, '政治', '1', '8c34448b-c65b-4a4e-a0da-83284d05f909');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10002', '关羽', 'm', 37, '物理', '1', 'b9111f83-d338-461d-8d46-f331087d5a42');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10003', '张飞', 'm', 38, '政治', '1', '1297510b-5f47-4425-b1cf-778425254142');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10004', '赵云', 'm', 29, '历史', '1', '940908e2-7c58-429a-bcef-8b566befed00');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10005', '黄忠', 'm', 68, '化学', '1', '05084723-77a8-425a-870e-e33d00e53fd2');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10006', '魏延', 'm', 35, '化学', '1', '37e4b3b4-3c76-4bf3-8165-f514d14ff54f');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10007', '马超', 'm', 29, '历史', '1', 'f8d34aac-93d6-47ab-915e-fcd169007f62');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10008', '姜维', 'm', 20, '政治', '1', 'd252f326-c0ac-46cb-82fc-cb2597edaf41');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10009', '孙策', 'm', 43, '政治', '2', 'e4b748e6-ff3c-4727-9fc2-458b97cb318d');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10010', '周瑜', 'm', 39, '数学', '2', 'c38f8afd-a6bc-458d-9f9a-fb22f30c7e39');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10011', '鲁肃', 'm', 34, '物理', '2', '71aaa4dd-9720-4f76-a825-357842de3c88');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10012', '吕蒙', 'm', 20, '数学', '2', 'dba0b7b9-97bf-41ac-8ac1-652b1fa05c9a');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10013', '孙权', 'm', 20, '政治', '2', '3f1e0276-8104-44a0-9231-2759777b08ee');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10014', '陆逊', 'm', 18, '数学', '2', '2120f7a5-00d9-44ff-92ee-ae1e2bc212e2');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10015', '曹操', 'm', 46, '政治', '3', '715c53ac-c85d-4049-9ef9-abf4e3d91d15');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10016', '典韦', 'm', 28, '历史', '3', '293745a9-c33e-47d2-9844-8668574d3b60');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10017', '曹仁', 'm', 40, '数学', '3', 'f29ca87a-7b85-4ed6-b57b-8ab75128487b');

insert into test.students (stdno, stdname, stdgender, stdage, stdmajor, stdclass, id)
values ('10018', '司马懿', 'm', 38, '政治', '3', '8793f911-fc0a-49fa-9ca7-2ab4e6a19454');