学习 PostgreSQL
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1255619/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Learning PostgreSQL
提问by phill
What's the best place to start learning PostgreSQL administration and programming in a Linux environment? What websites are the most recommended, concise and have easy to learn tutorials?
在 Linux 环境中开始学习 PostgreSQL 管理和编程的最佳地点是什么？哪些网站是最值得推荐的、简洁的、易于学习的教程？
I am already familiar with ANSI SQL from playing with SQL Server and MySQL; however, I've never touched PostgreSQL before. Any direction you can give is appreciated.
我已经通过使用 SQL Server 和 MySQL 熟悉了 ANSI SQL；但是，我以前从未接触过 PostgreSQL。您可以提供的任何方向都值得赞赏。
回答by Christopher
I have found the documentation on the webfor postgresql to be veryhigh quality.
回答by Petriborg
Having gone through this exact process about a year ago I found the following useful:
大约一年前经历了这个确切的过程后，我发现以下有用：
- psql prompt is your friend.
- The postgres online docsare great.
- This postgres book was greatfor both admin and programing for postgres driven programs.
- psql 提示是你的朋友。
- 在Postgres的在线文档是巨大的。
- 这本 postgres 书非常适合 postgres 驱动程序的管理和编程。
回答by porkbird
PostgreSQL documentation mentioned above is very comprehensive. Additionally you can find many PostgreSQL related blog posts on Planet PostgreSQL
上面提到的 PostgreSQL 文档非常全面。此外，您可以在Planet PostgreSQL上找到许多与 PostgreSQL 相关的博客文章
回答by porkbird
The PostgreSQL mailing listsare superb, particularly pgsql-general; they provide a level of help and support that couldn't be bought for any money.
PostgreSQL邮件列表非常棒，尤其是 pgsql-general；他们提供了用任何金钱都买不到的一定程度的帮助和支持。
回答by solaimuruganv
回答by KM.
best way to learn to admin a database is to download it, install it, and start it up and work through the problems/questions as they happen.
学习管理数据库的最佳方法是下载、安装并启动它，并在问题/问题发生时解决它们。
download from: http://www.postgresql.org/
下载地址：http: //www.postgresql.org/
Once you have it up and running, pick a topic to learn and read up on that one topic. Move from topic to topic, until you can do everything you want to do.
启动并运行后，选择一个主题来学习和阅读该主题。从一个话题转移到另一个话题，直到你可以做你想做的一切。
