PostgreSQL

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)

2021-09-10

1,461 reads

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)

2021-03-18

1,621 reads

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 (1)

2021-03-11

3,168 reads

Rules in PostgreSQL

  • Article

We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an extra query. As a result, rule execution impacts the performance of the system. Creating Rules A […]

5 (3)

2020-12-03

2,596 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

SQL join based on column value

By learner0

I am trying to join two tables based on the condition. Table1: ID   ...

Starting a career in cloud computing

By WojinRina

Hello, As the title says, might you have any advice to starting a career...

AWS S3 Questions

By lucasPeni

Hi all, Just starting out with AWS and had a few questions.. What are...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers