PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
2022-02-07
3,082 reads
PostgreSQL
Creating a Database and Tables in PostgreSQL: Learning PostgreSQL with Grant
The syntax for creating databases and tables in PostgreSQL is similar to other RDBMS. In this article, Grant Fritchey shows how to create databases and tables.
2022-01-31
PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
7,388 reads
Connecting to PostgreSQL: Learning PostgreSQL with Grant
Database professionals often work with more than one database platform. Grant Fritchey explains setting up and connecting to PostgreSQL database.
2021-12-17
PostgreSQL Date And Time Part 2
In the second part of this PostgreSQL date time series, we examine a number of commonly used functions for getting current dates and times and converting strings to dates and times.
2021-09-22
3,499 reads
Array and Custom Data Types in PostgreSQL
Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]
2021-09-10
13,367 reads
PostgreSQL Date And Time Part 1
This article shows the basics of using the age, and current date/time functions in PostgreSQL.
2021-08-09
2,456 reads
Getting a Query Execution Plan in PostgreSQL
Introduction You often need to check the performance of a PostgreSQL query you just wrote to look for some way to improve performance. In order to do this, you need a report of the query execution, which is called the execution plan). The query execution plan gives you the entire summary of the query execution […]
2021-03-18
9,595 reads
PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses
Overview A database clause is a conditional statement used to filter data from the database. There are various database clauses available in PostgreSQL, like Where, Order By, Group By, Having, Distinct, Limit, Fetch. In this first chapter of the tutorial we will cover Where, Order By, Group By clauses with suitable example. WHERE Clause The […]
2021-03-11
34,600 reads
Upgrade PostgreSQL 9.X to 12.X in Windows
Learn how you can upgrade a PostgreSQL server and ensure your databases follow to the new version.
2021-02-09
42,140 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers