PostGresql

{"label":"pg","expand":true,"children":[{"label":"基本概念","id":122,"expand":true,"children":[{"id":1695801111,"label":"关系型数据库"},{"id":1695801112,"label":"服务器和客户端"}]},{"label":"安装和使用","id":123,"expand":true,"children":[{"id":1695801113,"label":"安装"},{"id":1695801114,"label":"登录"},{"id":1695801115,"label":"使用"}]},{"label":"查询数据","id":124,"expand":true,"children":[{"id":1695801116,"label":"psql"},{"id":1695801117,"label":"SQL基本语法"},{"id":1695801118,"label":"SQL、DML和DDL"},{"id":1695801119,"label":"常见数据类型"}]},{"label":"基本结构","id":125,"expand":true,"children":[{"id":1695801120,"label":"表"},{"id":1695801121,"label":"函数"},{"id":1695801122,"label":"用户和权限"},{"id":1695801123,"label":"索引和约束"},{"id":1695801124,"label":"触发器"},{"id":1695801125,"label":"数据库扩展"}]},{"label":"服务端编程","id":126,"expand":true,"children":[{"id":1695801126,"label":"聚合和分组"},{"id":1695801127,"label":"连接查询"},{"id":1695801128,"label":"子查询"},{"id":1695801129,"label":"分页查询"},{"id":1695801130,"label":"CTE"},{"id":1695801131,"label":"过程化编程"},{"id":1695801132,"label":"DDL"}]},{"label":"集群和复制","id":127,"expand":true,"children":[{"id":1695801133,"label":"standby"},{"id":1695801134,"label":"流式复制集群"},{"id":1695801135,"label":"fdw"}]},{"label":"高级数据类型","id":128,"expand":true,"children":[{"id":1695801136,"label":"几何类型和GIS"},{"id":1695801137,"label":"JSON和JSONB"},{"id":1695801138,"label":"函数"},{"id":1695801139,"label":"视图"}]},{"label":"SQL高级技巧","id":129,"expand":true,"children":[{"id":1695801140,"label":"递归查询"},{"id":1695801141,"label":"Window Function"},{"id":1695801142,"label":"透视表"},{"id":1695801144,"label":"写入和冲突"},{"id":1695801145,"label":"事务"},{"id":1695801146,"label":"索引和优化"}]}]}