Skip to content

Category Archives: PostgreSQL

In PostgreSQL, the drop procedure statement removes a stored procedure. Syntax: drop procedure [if exists] procedure_name (argument_list) [cascade | restrict] Let’s analyze the above syntax:… Read More
In PostgreSQL, the Drop function statement is used to remove a function. Syntax: drop function [if exists] function_name(argument_list) [cascade | restrict] Let’s analyze the above… Read More
PostgreSQL CREATE PROCEDURE statement as the name suggests is used to create new stored procedures. So far, you have learned how to define user-defined functions… Read More
PostgreSQL allows the users to extend the database functionality with the help of user-defined functions and stored procedures through various procedural language elements, which are… Read More
In this article, we will look into the PostgreSQL Foreign key constraints using SQL statements. A foreign key is a column or a group of… Read More
JavaScript Backend can be developed using Node.js, Express, and Postgres. This backend can do Query operations on the PostgreSQL database and provide the status or… Read More
In PostgreSQL, the UNIQUE index to ensure the uniqueness of values in one or more columns. To create a UNIQUE index, you can use the… Read More
In PostgreSQL, we use the pr_indexes view to list the indexes of a database. PostgreSQL does not provide a command like SHOW INDEXES to list… Read More
In PostgreSQL the age() function is used to calculate ages. Syntax: age(timestamp, timestamp); Let’s analyze the above syntax: The age() function accepts two TIMESTAMP values… Read More
In PostgreSQL, the DATE_PART() function is used to query for subfields from a date or time value.  Syntax: DATE_PART(field, source) In the above syntax the… Read More
The PostgreSQL CURRENT_DATE function returns the current date. Syntax: CURRENT_DATE Return value: The CURRENT_DATE function returns a DATE value that represents the current date. Example… Read More
In PostgreSQL, the ALTER TABLESPACE statement is used to rename, change the owner, or set parameters for a tablespace. Syntax: ALTER TABLESPACE tablespace_name action; To… Read More
In PostgreSQL a tablespace is used to map a logical name to a physical location on disk. In the simplest word, we can understand tablespace… Read More
In this article, we will look into PostgreSQL group roles and their uses to manage privileges in a PostgreSQL database more effectively. It is a… Read More
In PostgreSQL the DROP ROLE statement to remove a role. Syntax: DROP ROLE [IF EXISTS] target_role; Let’s analyze the above syntax: After the DROP ROLE… Read More

Start Your Coding Journey Now!