PostgreSQL与MySQL有何不同? [英] How different is PostgreSQL to MySQL?

问题描述

有人要求我支持并使用PostgreSQL应用程序，但我是MySQL专家-这是一项现实的任务吗?

I've been asked to support and take on a PostgreSQL app, but am a MySQL guy - is this a realistic task?

推荐答案

PostgreSQL具有一些不错的功能，例如generate_series，自定义聚合函数，数组等，如果您花一些时间来学习它们，可以极大地简化您的生活

PostgreSQL has some nice features like generate_series, custom aggregate functions, arrays etc, which can ease your life greatly if you take some time to learn them.

另一方面，它缺少MySQL的某些功能，例如在查询中使用和分配会话变量，FORCE INDEX等，如果习惯了这些功能，这会很烦人.

On the other hand it lacks some features of MySQL like using and assigning session variables in queries, FORCE INDEX, etc., which is quite annoying if you are used to these features.

如果仅使用基本的SQL，则几乎不会发现任何差异.

If you just use basic SQL, then you will hardly notice any difference.

这篇关于PostgreSQL与MySQL有何不同?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！