Skip to content

Tag Archives: postgreSQL-administration

A Cursor in PostgreSQL is used to process large tables. Suppose if a table has 10 million or billion rows. While performing a SELECT operation… Read More
 If you are a part of a corporation, it is highly unlikely that you have the admin privileges to install any external software. But the… Read More
There are several password-based authentication methods available. in PostgreSQL These methods operate in the same way but differ in how the users’ passwords are stored… Read More
PostgreSQL provides the ASSERT statement for inserting important debugging checks in the PL/pgSQL code.It is an important tool for checking logical errors and may be… Read More
PostgreSQL API for Python allows user to interact with the PostgreSQL database using the psycopg2 module. In this article we will look into the process… 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
In this article, we will look into the step-by-step process of resetting the Postgres user password in case the user forgets it. PostgreSQL uses the … Read More
In PostgreSQL, the DROP TABLESPACE statement is used to remove a tablespace. Syntax: DROP TABLESPACE [IF EXISTS] tablespace_name; Let’s analyze the above syntax: First, specify… Read More
PostgreSQL uses roles to represent user accounts. It doesn’t use the user concept like other database systems. Typically, roles can log in are called login… Read More
In PostgreSQL, the GRANT statement is used to grant privileges to a role to alter on database objects like tables, views, functions, etc. The following… Read More
In PostgreSQL, the REVOKE statement is used to revoke previously granted privileges on database objects through a role. The following shows the syntax of the… Read More
In PostgreSQL, the ALTER ROLE statement is used to manage and modify roles. It can be used to modify the name of a role, the… Read More
PL/pgSQL is a block-structured language, therefore, a PL/pgSQL function or store procedure is organized into blocks. Syntax: [ <<label>> ] [ DECLARE declarations ] BEGIN… Read More
In PostgreSQL, the CTE(Common Table Expression) is used as a temporary result set that the user can reference within another SQL statement like SELECT, INSERT,… Read More