Similar Topics

Web Technologies32.1K+ articles

DSA20.5K+ articles

Python19.6K+ articles

Experiences15.8K+ articles

Interview Experiences14.5K+ articles

School Learning11.1K+ articles

JavaScript9.9K+ articles

Databases1.9K+ articles

PostgreSQL386+ articles

postgreSQL-administration19+ articles

postgreSQL-managing-database

13 posts

Run PostgreSQL on Docker and Setting Up pgAdmin

Last Updated: 23 July 2025

PostgreSQL, an effective tool, is a free-to-use relational database management system. Docker can quickly construct and orchestrate its instances without bothering about...read more

postgreSQL-managing-database

Geeks Premier League 2023

PostgreSQL - Connect and Access a Database

Last Updated: 23 July 2025

In this article, we will learn about how to access the PostgreSQL database. Once the database is created in PostgreSQL, we can access it in two ways using:psql: PostgreSQL...read more

article_image

Geeks Premier League

Geeks-Premier-League-2022

postgreSQL-managing-database

PostgreSQL - Backup Database

Last Updated: 22 August 2024

All commercial firms and corporations are never 100% free of data threats. Being wary of scenarios like data corruption, host or network failures or even deliberate storag...read more

article_image

postgreSQL-managing-database

PostgreSQL - COMMIT

Last Updated: 23 July 2025

The COMMIT command in PostgreSQL is important for saving the changes made during a transaction. Without executing a COMMIT, all the data manipulation operations performed ...read more

article_image

Technical Scripter

Technical Scripter 2020

postgreSQL-managing-database

PostgreSQL - Transactions

Last Updated: 01 August 2026

A PostgreSQL transaction groups one or more SQL statements (such as INSERT, UPDATE, DELETE and SELECT) into a single unit of work. It ensures that either all operations ar...read more

Technical Scripter

Technical Scripter 2020

postgreSQL-managing-database

PostgreSQL - Connecting to the Database using Python

Last Updated: 15 July 2025

PostgreSQL in Python offers a robust solution for developers looking to interact with databases seamlessly. With the psycopg2 tutorial, we can easily connect Python to Pos...read more

article_image

postgreSQL-administration

postgreSQL-managing-database

PostgreSQL - Show Databases

Last Updated: 08 July 2026

The SHOW DATABASES command is used to retrieve and display all databases accessible to the current user in a DBMS. It simplifies database management by avoiding direct que...read more

article_image

postgreSQL-managing-database

PostgreSQL - Errors and Messages

Last Updated: 01 August 2026

Errors and messages in PostgreSQL provide information about the execution of SQL statements and PL/pgSQL programs. Messages are commonly used for debugging and displaying ...read more

postgreSQL-managing-database

PostgreSQL - Copy Database

Last Updated: 15 July 2025

Copying a PostgreSQL database is essential for tasks like testing, backup, and database migration. PostgreSQL offers efficient tools for duplicating databases either withi...read more

postgreSQL-managing-database

PostgreSQL - DROP DATABASE

Last Updated: 10 July 2026

The DROP DATABASE statement in PostgreSQL is used to permanently delete an existing database from the PostgreSQL server. Removes the database along with all its tables, vi...read more

article_image

postgreSQL-managing-database

PostgreSQL ALTER DATABASE

Last Updated: 28 July 2026

PostgreSQL ALTER DATABASE command modifies the properties of an existing database, such as its name, owner, configuration settings or connection limits. It helps administr...read more

article_image

postgreSQL-managing-database

PostgreSQL - Rename Database

Last Updated: 10 July 2026

Renaming a database in PostgreSQL is done to change the database name without affecting its data or structure. It is used to:Change the database name for better identifica...read more

article_image

postgreSQL-managing-database

Loading a Database in PostgreSQL

Last Updated: 06 July 2026

Loading a database in PostgreSQL refers to importing data from a file or backup into a PostgreSQL database. It is commonly used to restore databases, migrate data or popul...read more

article_image

postgreSQL-administration

postgreSQL-managing-database