Skip to content

Tag Archives: postgreSQL-basics

PostgreSQL is one of the most advanced general-purpose object-relational database management systems, and it is open-source. PostgreSQL objects include tables, views, and columns. In this… Read More
Strictly speaking, this process is iteration, not recursion, but RECURSIVE is the terminology chosen by the SQL standards committee. The general structure of the Postgres… Read More
PostgreSQL is a powerful, open-source object-relational database system that aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments. It… Read More
PostgreSQL BEGIN command is used to initiate a transaction. A transaction is nothing but a unit of work done in the database, the work can… Read More
PostgreSQL provides the for loop statements to iterate over a range of integers or over a result set or over the result set of a… Read More
This article will be focusing on copying an existing table to a new table in PostgreSQL. This might come in handy while creating new tables… Read More
In PostgreSQL, the select into statement to select data from the database and assign it to a variable. Syntax: select select_list into variable_name from table_expression;… Read More
In PostgreSQL, a variable is a meaningful name for a memory location. A variable holds a value that can be changed through the block or function. A variable… Read More
PostgreSQL has a conditional expression called CASE to form conditional queries. The PostgreSQL CASE expression is the same as IF/ELSE statement in other programming languages.… Read More
In PostgreSQL, the SELECT INTO statement allows users to create a new table and inserts data returned by a query. The new table columns have… Read More
A sequence in PostgreSQL is a user-defined schema-bound object that yields a sequence of integers based on a specified specification. The CREATE SEQUENCE statement is… Read More
Psql is an interactive terminal to work with the PostgreSQL database. It is used to query data from the PostgreSQL database server faster and more… Read More
In this article we will discuss the process of constructing complex queries using the PostgreSQL subquery. Subqueries in the simplest term can be defined as… Read More
This is a step-by-step guide to install PostgreSQL on a Linux machine. By default, PostgreSQL is available in all Ubuntu versions as PostgreSql “Snapshot”. However… Read More
To delete data from a table PostgreSQL has a DELETE statement. Syntax: DELETE FROM table WHERE condition; The below rules need to be followed while… Read More