postgresql analysis:测试任务以创建postgresql模式填充数据创建一些请求并进行分析以改善它们 源码

数据库架构创建 创建一个数据库架构来保存以下信息: 作者: "name", "country" "J. D. Salinger", "US" "F. Scott. Fitzgerald", "US" "Jane Austen", "UK" "Leo Tolstoy", "RU" "Sun Tzu", "CN" "Johann Wolfgang von Goethe", "DE" "Janis Eglitis", "LV" 图书: "name", "author", "pages" "The Catcher in the Rye", "J. D. Salinger", 300 "Nine Stories", "J. D. Salinger", 200 "Franny and Zooey", "J. D. Salinger", 150 "The Great Gatsby", "F. Sc