Shivayan Mukherjee

A professional software developer having more than 11yrs of industry experience in Java, SQL, microservices across multiple domains such as insurance, airlines, telecom, healthcare.
  • Interests: coding, travelling, outdoor games

SQLServerCentral Article

PostgreSQL Triggers Part 2

Article Overview In this article, we will learn how to drop, alter, enable, and disable a PostgreSQL trigger. In the 1st part of this series, we got an overall view of database triggers, PostgreSQL-specific triggers, types of PostgreSQL triggers, and how to create a trigger with basic syntax and examples. If you haven't read it […]

You rated this post out of 5. Change rating

2022-09-23

1,568 reads

SQLServerCentral Article

PostgreSQL Hibernate Integration

Overview PostgreSQL is a free and general purpose open source object-relational database system that uses and extends the SQL language while Hibernate is probably the most popular ORM tool. If you are not familiar with PostgreSQL then I suggest you to go through this link below before going ahead in this article. This article is […]

(1)

You rated this post out of 5. Change rating

2021-07-16

26,267 reads

SQLServerCentral Article

PostgreSQL HAVING,LIMIT and FETCH Clauses

Overview In this article, we will cover these PostgreSQL clauses with examples: HAVING, LIMIT and FETCH. In a previous article we discussed the WHERE, ORDER BY and GROUP BY  clauses. Click the link if you wish to learn about those clauses. HAVING Clause The HAVING clause works on grouped data returned by a GROUP BY. […]

(1)

You rated this post out of 5. Change rating

2021-06-25 (first published: )

3,112 reads

Blogs

Webinar: Navigating the Database Landscape in 2026

By

For a number of years, we’ve produced the State of the Database Landscape report,...

Claude AI Convinced Me Not to Build an iPad App

By

I coach volleyball and I do a lot of stat stuff on paper. I...

A New Word: Dolorblindness

By

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Read the latest Blogs

Forums

The Power of Data and Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Power of Data and...

What's the Date?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the Date?

Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Two New Shortcuts for Fabric...

Visit the forum

Question of the Day

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

See possible answers