Similar Topics

Web Technologies32.1K+ articles

DSA20.5K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

Databases1.9K+ articles

how-to-install1.2K+ articles

PostgreSQL386+ articles

postgreSQL-managing-table38+ articles

postgreSQL-basics

21 posts

PostgreSQL - Naming Conventions

Last Updated: 23 July 2025

PostgreSQL naming conventions provide guidelines for naming database object names in PostgreSQL, including tables, columns, indexes and constraints. In this article, We wi...read more

postgreSQL-basics

PostgreSQL - Recursive Query Using CTEs

Last Updated: 23 July 2025

Recursive queries are a powerful feature in PostgreSQL that allow you to perform iterative operations within a database. While strictly speaking, this process is iteration...read more

postgreSQL-basics

PostgreSQL - Cheat Sheet : Basic to Advanced

Last Updated: 23 July 2025

PostgreSQL is a powerful, open-source object-relational database management system (ORDBMS). It is designed to help developers build robust applications and allow administ...read more

article_image

postgreSQL-basics

PostgreSQL - For Loops

Last Updated: 28 July 2026

The PostgreSQL FOR loop is a control structure in PL/pgSQL that executes a block of statements repeatedly for a specified range of values or for each row returned by a que...read more

article_image

Technical Scripter

Technical Scripter 2020

postgreSQL-basics

PostgreSQL - BEGIN

Last Updated: 23 July 2025

The BEGIN command in PostgreSQL is essential for transaction management, allowing a sequence of SQL operations to be executed as a single unit of work. This ensures data c...read more

article_image

Technical Scripter

Technical Scripter 2020

postgreSQL-basics

PostgreSQL - Copy a Table

Last Updated: 23 July 2025

This article will focus on copying an existing table to a new table in PostgreSQL. This might come in handy while creating new tables that would either have the same data ...read more

article_image

postgreSQL-basics

PostgreSQL - Select Into

Last Updated: 15 July 2025

In PostgreSQL, the select into statement to select data from the database and assign it to a variable.Syntax:select select_listinto variable_namefrom table_expression;In t...read more

postgreSQL-managing-table

postgreSQL-basics

PostgreSQL - Variables

Last Updated: 15 July 2025

PostgreSQL, one of the most powerful and advanced open-source relational database management systems, provides robust support for procedural programming through its PL/pgS...read more

postgreSQL-basics

PostgreSQL - CASE

Last Updated: 28 July 2026

PostgreSQL CASE expression is used to apply conditional logic in SQL queries. It works similarly to the IF...ELSE statement in programming languages, allowing you to retur...read more

article_image

postgreSQL-basics

PostgreSQL - CREATE SEQUENCE

Last Updated: 15 July 2025

In database management, generating unique identifiers is vital for data integrity, and PostgreSQL provides a powerful feature called CREATE SEQUENCE to solve this. This co...read more

article_image

postgreSQL-managing-table

postgreSQL-basics

PostgreSQL - SELECT INTO

Last Updated: 15 July 2025

The PostgreSQL SELECT INTO statement allows users to create a new table directly from the result set of a query. This command is ideal for duplicating or organizing data f...read more

article_image

postgreSQL-basics

PostgreSQL - Subquery

Last Updated: 12 July 2025

Subqueries, also known as nested queries or inner queries, are queries embedded within another SQL query. They allow you to perform multiple queries within a single Postgr...read more

article_image

postgreSQL-basics

PostgreSQL - DELETE

Last Updated: 28 July 2026

The DELETE statement in PostgreSQL is used to remove one or more rows from a table. The WHERE clause specifies which rows should be deleted. If the WHERE clause is omitted...read more

article_image

postgreSQL-managing-table

postgreSQL-basics

PostgreSQL UPDATE Statement

Last Updated: 28 July 2026

The PostgreSQL UPDATE statement is used to modify existing data in a table by changing the values of one or more columns.The WHERE clause specifies which rows should be up...read more

article_image

postgreSQL-managing-table

postgreSQL-basics

PostgreSQL - INSERT

Last Updated: 28 July 2026

The INSERT statement in PostgreSQL is used to add one or more new rows to a table. It allows you to insert values into all columns or only selected columns. PostgreSQL als...read more

article_image

postgreSQL-managing-table

postgreSQL-basics

1 2