Courses
Tutorials
Practice

Similar Topics

Web Technologies37.4K+ articles

DSA22.8K+ articles

Python21.3K+ articles

Experiences16.6K+ articles

Interview Experiences14.2K+ articles

JavaScript12.2K+ articles

School Learning11.5K+ articles

Java10.8K+ articles

Databases2.2K+ articles

PostgreSQL394+ articles

postgreSQL-constraints

5 posts

PostgreSQL - DISTINCT ON expression

Last Updated: 11 October 2024

The DISTINCT ON clause in PostgreSQL allows us to retrieve unique rows based on specific columns by offering more flexibility than the standard DISTINCT clause. DISTINCT O...read more

postgreSQL-constraints

PostgreSQL - UNIQUE Constraint

Last Updated: 13 August 2024

In PostgreSQL, the UNIQUE constraint is a powerful tool used to ensure that values stored in a column or a group of columns are unique across rows in a table. This constra...read more

article_image

postgreSQL-constraints

PostgreSQL - CHECK Constraint

Last Updated: 06 August 2024

In PostgreSQL, the CHECK constraint is a powerful tool used to enforce data integrity by specifying that a value in a column must meet a specific requirement. The CHECK co...read more

article_image

postgreSQL-constraints

PostgreSQL - NOT NULL Constraint

Last Updated: 08 July 2024

In PostgreSQL, the NOT NULL constraint is a fundamental feature to ensure that a column cannot contain NULL values. NULL represents unknown or missing information in datab...read more

article_image

postgreSQL-constraints

PostgreSQL - Primary Key

Last Updated: 18 November 2024

A primary key in PostgreSQL is a column (or a set of columns) that uniquely identifies each row in a table. It is an important component for ensuring data integrity and pl...read more

article_image

postgreSQL-constraints