SQL Server Terms Translated into PostgreSQL
The rise in popularity of open-source RBDMs has encouraged many organizations to adopt PostgreSQL, but as a DBA or Developer, it can be challenging when exploring new database platforms, no matter how experienced you are.
When looking at SQL Server, it has many similarities to PostgreSQL, but there are several big differences too.
To better understand these, we’ve created a useful reference guide that will help you translate well-known SQL Server terms into their PostgreSQL equivalents, making the journey to PostgreSQL that bit easier.
Want to keep this guide handy? Get the PDF version here
Read next
Product learning article
Managing PostgreSQL Extensions Using Flyway
Any reliable DevOps deployment process must not only deliver the right database code but also ensure that the correct conditions exist for the deployment to succeed. For PostgreSQL databases, this includes ensuring that any extensions on which the database code relies are installed, and at the correct version. Fortunately, Flyway will automatically track which extensions are installed on a database and at what version, so we can 'propagate' these changes accurately during deployments and avoid inconsistencies in database behavior and even application breakages.
Product learning article
Six Things to Monitor with PostgreSQL
This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like Redgate Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users.
Simple steps to get started
Learning PostgreSQL?
Join our webinar series, which follows Developer Advocates, Ryan Booz and Grant Fritchey, as they guide you through the what, how and why of the database system, breaking down key topics into easy-to-follow sessions.