PostgreSQL – Truncate Table

ByAdmin June 2, 2023June 2, 2023

In PostgreSQL, the TRUNCATE command is used to remove all data from a table while preserving the structure of the table. TRUNCATE statement is faster than the DELETE statement to delete all the rows of a table.

Below is the syntax of the TRUNCATE command:

TRUNCATE TABLE table_name;

In the above command table_name is the name of the table that you would like to truncate the data from.

TRUNCATE command cannot be undone. Once you truncate a table, all data in the table will be permanently deleted.

You can truncate multiple tables at once as shown below by using a comma-separated list of table names:

TRUNCATE TABLE table1, table2, table3;

If the table has any dependent objects, such as indexes, views, or triggers, they will be automatically dropped when you truncate the table.

You can use the CASCADE option to delete data from the dependent objects along with the primary table.

TRUNCATE TABLE table_name CASCADE;

Data Manipulation

PostgreSQL – INSERT Multiple Rows

ByAdmin August 21, 2023August 21, 2023

You can insert multiple rows into a table using the INSERT INTO statement in PostgreSQL database. There are a few different ways to accomplish this, depending on your requirements and the format of the data you want to insert. The two common methods of inserting multiple values are: using the VALUES clause and using the…

Data Manipulation

PostgreSQL – Delete Data from a Table

ByAdmin June 2, 2023June 7, 2023

To add a new column to a table in PostgreSQL, you can use the ALTER TABLE statement with the ADD COLUMN clause. Syntax is as shown below: ALTER TABLE table_name ADD COLUMN column_name data_type [column_constraints]; Where: Below is an example to add a new column “email” of data type varchar(255) to a table “users”. ALTER…

Data Manipulation

PostgreSQL – Insert into Table

ByAdmin June 2, 2023September 22, 2023

To insert data into a table in PostgreSQL, you can use the INSERT statement. Below is the syntax: INSERT INTO table_name (column1, column2, column3, …) VALUES (value1, value2, value3, …); Below is an example of inserting data into a table named “employees” with columns “id”, “name”, and “age”: INSERT INTO employees (name, department, salary) VALUES…

Data Manipulation

PostgreSQL – Update data in a Table

ByAdmin June 2, 2023June 7, 2023

The PostgreSQL UPDATE statement can be used to modify existing records in a table. The basic syntax of the UPDATE statement is as follows: UPDATE table_name SET column1 = value1, column2 = value2, … WHERE conditions; Below is an example to demonstrates the usage of the UPDATE statement: Consider a table named “employees” with the…

Data Manipulation

PostgreSQL – UPSERT

ByAdmin August 29, 2023August 29, 2023

An “upsert” operation refers to the ability to update an existing row if it exists, or insert a new row if it doesn’t exist, based on a specified condition. The upsert operation is also known as “merge” or “insert on conflict update.” INSERT INTO target_table (column1, column2, …) VALUES (value1, value2, …) ON CONFLICT (unique_constraint_columns)…

Related

Similar Posts