PostgreSQL

SQLServerCentral Article

Array and Custom Data Types in PostgreSQL

  • Article

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 […]

5 (2)

You rated this post out of 5. Change rating

2021-09-10

10,897 reads

SQLServerCentral Article

Getting a Query Execution Plan in PostgreSQL

  • Article

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 […]

5 (1)

You rated this post out of 5. Change rating

2021-03-18

7,309 reads

SQLServerCentral Article

PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses

  • Article

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 […]

4.5 (2)

You rated this post out of 5. Change rating

2021-03-11

24,980 reads

Blogs

Extended Events in Azure Data Studio

By

I know I can use extended events (xevents) in Azure SQL DB when in...

Azure Workbooks

By

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

Read the latest Blogs

Forums

Creating Aggregates

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating Aggregates

Getting Started with DDL statements of Cassandra Query Language

By Shivayan Mukherjee

Comments posted to this topic are about the item Getting Started with DDL statements...

The Balanced Technical Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Balanced Technical Manager

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers