当前位置: 首页 > 电脑软件> 应用软件>PostgreSQL中文学习手册(PDF)下载9.1 免费版

PostgreSQL中文学习手册(PDF)下载9.1 免费版

PostgreSQL中文学习手册(PDF)下载9.1 免费版

软件大小:2.048MB|软件分类: 应用软件|版本:
软件授权:免费软件  |应用环境:all-win     |更新时间:2019-12-17
检测:安全无毒、无广告、无插件

小编推荐下载
应用软件排行榜
软件介绍

     postgresql中文资料国内不多,整理出来与大家分享,该作品是PDF文件格式请下载 福昕PDF阅读器,欢迎下载体验。

截图:

postgresql中文手册 9.1 PDF

目录:

PostgreSQL 学习手册(数据表) .............................................................................................................................................. 4
一、表的定义: ............................................................................................................................................................... 4
PostgreSQL 学习手册(模式 Schema) ..................................................................................................................................... 9
PostgreSQL 学习手册(表的继承和分区) ............................................................................................................................ 10
一、表的继承: ............................................................................................................................................................. 10
PostgreSQL 学习手册(常用数据类型) ................................................................................................................................ 16
一、数值类型: ............................................................................................................................................................. 16
六、数组: ..................................................................................................................................................................... 22
PostgreSQL 学习手册(函数和操作符<一>) ........................................................................................................................ 25
一、逻辑操作符: ......................................................................................................................................................... 25
四、字符串函数和操作符: ......................................................................................................................................... 27
五、位串函数和操作符: ............................................................................................................................................. 29
PostgreSQL 学习手册(函数和操作符<二>) ........................................................................................................................ 30
六、模式匹配: ............................................................................................................................................................. 30
八、时间/日期函数和操作符: .................................................................................................................................... 33
PostgreSQL 学习手册(函数和操作符<三>) ........................................................................................................................ 35
九、序列操作函数: ..................................................................................................................................................... 35
十二、系统信息函数: ................................................................................................................................................. 38
PostgreSQL 学习手册(索引) ................................................................................................................................................ 42
一、索引的类型: ......................................................................................................................................................... 42
四、唯一索引: ............................................................................................................................................................. 43
PostgreSQL 学习手册(事物隔离) ...................................................................................................................................... 45
PostgreSQL 学习手册(性能提升技巧) ................................................................................................................................ 46
一、使用 EXPLAIN: ...................................................................................................................................................... 46
PostgreSQL 学习手册(服务器配置) .................................................................................................................................. 50
一、服务器进程的启动和关闭: ................................................................................................................................. 50
PostgreSQL 学习手册(角色和权限) .................................................................................................................................... 52
PostgreSQL 学习手册(数据库管理) ................................................................................................................................ 54
一、概述: ..................................................................................................................................................................... 54
PostgreSQL 学习手册(数据库维护) .................................................................................................................................. 56
一、恢复磁盘空间: ..................................................................................................................................................... 56
二、更新规划器统计: ................................................................................................................................................. 57
四、定期重建索引: ..................................................................................................................................................... 59
PostgreSQL 学习手册(系统表) ............................................................................................................................................ 61
一、pg_class: .................................................................................................................................................................. 61
三、pg_attrdef: ............................................................................................................................................................... 63
四、pg_authid: ................................................................................................................................................................ 64
五、pg_auth_members: ................................................................................................................................................. 64
七、pg_tablespace: ......................................................................................................................................................... 65
十、pg_index: ................................................................................................................................................................. 67
PostgreSQL 学习手册(系统视图) ........................................................................................................................................ 68
一、pg_tables: ................................................................................................................................................................ 68
二、pg_indexes: .............................................................................................................................................................. 68
三、pg_views: ................................................................................................................................................................. 68
四、pg_user: ................................................................................................................................................................... 69
五、pg_roles: .................................................................................................................................................................. 69
六、pg_rules: .................................................................................................................................................................. 69
七、pg_settings: ............................................................................................................................................................. 70
PostgreSQL 学习手册(客户端命令<一>) ............................................................................................................................ 70
零、口令文件: ............................................................................................................................................................. 70
PostgreSQL 学习手册(客户端命令<二>) ............................................................................................................................ 75
七、pg_dump:................................................................................................................................................................. 75
八、pg_restore: .............................................................................................................................................................. 77
PostgreSQL 学习手册(SQL 语言函数) ................................................................................................................................. 83
一、基本概念: ............................................................................................................................................................. 83
PostgreSQL 学习手册(PL/pgSQL 过程语言) ....................................................................................................................... 86
一、概述: ..................................................................................................................................................................... 86

展开更多
网友评论