PostgreSQL create extension

The Postgresql database management system is used to store data in tabular form. The database applies several functions to the data stored in the relationship. To enhance and support these features in a PostgreSQL database, there is an approach to extending database functionality with SQL objects. These extensions are intended to be used as additional […]

Postgresql Named Parameters

The PostgreSQL control system forces functions to have named parameters using either positional notation or named notation. We use named notation mainly when we need to pass a large number of parameters; using this, the relationship between function arguments and parameters becomes more explicit. Although we use functions or procedures in PostgreSQL, this allows us […]

Removing a sequence (sequences) in PostgreSQL

The PostgreSQL database offers various features and one of them is PostgreSQL Sequence. A PostgreSQL sequence is a database-related object that is used to create a sequence of values ​​starting from a specific value. It usually takes a starting point, an increment value, the minimum value it can have, and the maximum value it can […]

Find PostgreSQL database size?

This article will help you determine the size of a database in PostgreSQL. The database size includes tables, schemas, functions, and triggers. The contents of database tables can grow exponentially, which directly increases the size of the database. Thus, this resizing should be regularly monitored by the administrator so that the memory allocation for the […]

Scroll to top