May 2025
Intermediate to advanced
314 pages
4h 10m
Chinese
Content preview from PostgreSQL：快速入门，第3版Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
附录 A. 安装 PostgreSQL
Windows 和桌面 Linux
EnterpriseDB为 Windows 和 Linux 的桌面版本构建了 安装程序。它们为每个操作系统提供 32 位和 64 位版本。
安装程序易于使用。它们与 PgAdmin（PostgreSQL 9.6 以上版本附带 pgAdmin4，而旧版本附带 pgAdmin3）和堆栈生成器打包在一起，你可以从中安装 JDBC、.NET 驱动程序、Ruby、PostGIS、phpPgAdmin 和 pgAgent 等附加组件。
EnterpriseDB 有两种 PostgreSQL 产品：PostgreSQL 的官方开源版本，称为 Community Edition；以及其专有版本，称为 Advanced Plus。专有分叉版兼容 Oracle 并增强了管理功能。在下载安装程序时，不要混淆这两种版本。在本书中，我们重点介绍的是官方版PostgreSQL，而不是Postgres Plus Advanced Server；不过，许多内容都适用于Postgres Plus Advanced Server。
BigSQL是一个开放源的 PostgreSQL 发行版，主要由 OpenSCG 公司资助。BigSQL 发行版与 EnterpriseDB 类似，有适用于 64 位版本 Windows、Mac 和 Linux 的安装程序。
它比 EnterpriseDB 发行版更新，以互操作性、DevOps 和大数据为目标。因此，它包含了其他发行版中常见的扩展。它与pgTSQL（一种程序语言，可模拟 Microsoft SQL Server 的 Transact-SQL 存储过程语言）以及大量用于基准测试和监控的好东西（如 pgBadger）一起打包。
您还会发现其他增强功能，如PostGIS（包括 ogr_fdw）、许多其他 FDW（如hadoop_fdw、cassandra_fdw、oracle_fdw 和各种 PL）。
与 EnterpriseDB 一样，BigSQL 也有自己的安装系统。安装程序可以通过 Web 界面触发，也可以通过他们称为pgc 的 shell 命令行工具触发，它代表 "相当不错的命令行"。pgc 软件包管理工具遵循与 Linux yum、apt-get 等相同的模式，即使在 Windows 上也是如此。因此，要安装新软件包，首先打开 shell 提示，将目录更改为安装 BigSQL 的文件夹。
更新本地软件包列表并查看软件包列表：
pgc update pgc list
输出结果将显示如下内容
Category | Component | Version | ReleaseDt | Status | Cur? PostgreSQL pg92 9.2.21-1 2017-05-11 1 PostgreSQL pg93 9.3.17-1 2017-05-11 1 PostgreSQL pg94 9.4.12-1 2017-05-11 1 PostgreSQL pg95 9.5.7-1 2017-05-11 1 PostgreSQL pg96 9.6.3-1 2017-05-11 Installed 1 Extensions cassandra_fdw3-pg96 3.0.1-1 2016-11-08 1 Extensions hadoop_fdw2-pg96 2.5.0-1 2016-09-01 1 Extensions oracle_fdw1-pg96 1.5.0-1 2016-09-01 1 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.