The Developer Space

Developer's Cafe

  • Cloud
  • Database
  • Open Source
  • Programming
  • Web Dev
  • Mobile
  • Security
  • QuickRef
  • Home
  • Database
  • PostgreSQL
  • Check PostgreSQL Edition

Check PostgreSQL Edition

Shameel Ahmed - AWS, CodeProject, PostgreSQL
July 29, 2019September 21, 2019 No Comments
0 0
Read Time43 Second

If you are developing a product that runs on PostgreSQL, and supports both the Open Source Edition and AWS Aurora (PostgreSQL compatible) Edition and you would like to know which Edition you are on, there is a neat and simple trick.

SELECT aurora_version();

This would return the Aurora version (something like 2.2.1, etc.) if it is running Aurora or throw an error if it is PostgreSQL Open Source edition.

If you would just like to know the PostgreSQL version irrespective of the Edition, you can use:

SELECT version();

This will return the underlying PostgrSQL version for both the Open Source and the Aurora Editions.

Share

Facebook
Twitter
LinkedIn
Email

Post navigation

Restrict access to SQL Server Data using a Facade Database
PostgreSQL finally gets Stored Procedures

Related Articles

Serverless

Evaluating if Serverless is suitable for your needs – A comprehensive analysis

Shameel Ahmed
September 17, 2023September 17, 2023 No Comments
Invoke OpenAI APIs from API Gateway

How to build a REST API using Amazon API Gateway to invoke OpenAI APIs

Shameel Ahmed
March 11, 2023March 11, 2023 1 Comment

How to fix “‘StreamingBody’ object is not subscriptable” in AWS Lambda boto3

Shameel Ahmed
February 12, 2023February 12, 2023 No Comments

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
(Add your review)

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

.NET Architecture Artificial Intelligence ASP.NET AWS Azure Books C# Career Cloud CodeProject Conversational Bots Database Data Security Facade GCP IDEs Java Mobile MongoDB MySQL Open Source Patterns PostgreSQL Programming Python Redis Security Serverless SQL Server Tools Uncategorized Web Development Windows Phone

Recent Posts

  • Evaluating if Serverless is suitable for your needs – A comprehensive analysis September 17, 2023
  • 5 reasons you should switch from VS Code to VSCodium June 10, 2023
  • How to build a REST API using Amazon API Gateway to invoke OpenAI APIs March 11, 2023
  • How to fix “‘StreamingBody’ object is not subscriptable” in AWS Lambda boto3 February 12, 2023
  • How to invoke OpenAI APIs from AWS Lambda functions February 5, 2023

Archives

  • September 2023 (1)
  • June 2023 (1)
  • March 2023 (1)
  • February 2023 (2)
  • January 2023 (2)
  • December 2022 (1)
  • October 2022 (1)
  • July 2022 (2)
  • February 2022 (1)
  • November 2021 (1)
  • July 2021 (1)
  • June 2021 (1)
  • September 2020 (1)
  • May 2020 (2)
  • April 2020 (1)
  • October 2019 (1)
  • September 2019 (4)
  • July 2019 (2)
  • May 2018 (1)
  • September 2017 (1)
  • April 2017 (1)
  • April 2014 (1)
  • August 2011 (1)
  • June 2009 (1)
Copyright 2022. The Developer Space | Theme: OMag by LilyTurf Themes
  • DbStudio
  • Re:Link
  • shameel.net
  • Privacy Policy
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
SAVE & ACCEPT