PostgreSQL (Postgres) Community

Postgres - Blog

Porus Homi Havewala
Follow /2 Aug 2017 at 5:43pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility – Benefits and Drawbacks – Part VII

In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS); in particular, Amazon’s own Aurora database with PostgreSQL compatibility. We examined in detail the benchmark results...
183 0 /
Bruce Momjian
Follow /13 Jul 2017 at 12:51am / Postgres - Blog

Allowing Only One NULL

While the SQL standard allows multiple NULLS in a unique column, and that is how Postgres behaves, some database systems (e.g. MS_SQL ) allow only a single NULL in such cases. Users migrating from other database systems sometimes want to emulate this...
222 0 /
Bruce Momjian
Follow /13 Jul 2017 at 12:41am / Postgres - Blog

Postgres Keywords

You might be aware that the SQL standard reserves certain identifiers that cannot be used for naming user objects. Postgres follows that standard, with slight modifications. For example, you cannot create a table called all: CREATE TABLE all (x INTEGER...
230 0 /
Porus Homi Havewala
Follow /11 Jul 2017 at 5:08pm / Postgres - Blog

A First Look at Amazon Aurora with PostgreSQL Compatibility - Benefits and Drawbacks - Part VI

by Porus Homi Havewala In the previous parts of this article series, we started to look at Amazon AWS and its Relational Database Service (Amazon RDS). This included Amazon’s own Aurora database with MySQL compatibility and Aurora with PostgreSQL...
473 0 /
Porus Homi Havewala
Follow /6 Jun 2017 at 7:29pm / Postgres - Blog

A first look at Amazon Aurora with PostgreSQL compatibility - Benefits and Drawbacks - Part V

by Porus Homi Havewala In the previous parts of this article series, we had a first look at Amazon AWS and the Relational Database Service (Amazon RDS) that it offers to customers around the world. We zoomed in on Amazon’s own Aurora database...
948 0 /