欧洲杯名字 (关于欧洲杯名字 玩法)

该作品是PDF文件格式请下载 福昕PDF阅读器

postgresql中文资料国内不多，整理出来与大家分享

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