Skip to content

Tag Archives: postgreSQL-basics

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
PostgreSQL has an UPDATE statement that is used to update or modify an existing data in the table. Syntax: UPDATE table SET column1 = value1,… Read More
In PostgreSQL, the INSERT statement is used to add new rows to a database table. As one creates a new database, it has no data… Read More
In this article we will be looking into the basic use of PostgreSQL SELECT statement to query data from the database table. For the sake… Read More