These PostgreSQL Queries are the principal structures for recovering data from the database. And these PostgreSQL Queries contains pretend designs that is displayed from the database. Numerous database administration frameworks utilizes Structured Query Language as a basic design structures related to query. PostgreSQL Queries statements can be classified into the following types:

By using insert command a new record can be inserted in the existing database table. i.e, inserting field value like emp_id, emp_name and salary can be inserted.

In the SQLDB database, employee21 table has been created.

Right click on employee21 table and select Script followed by Create Script.

Employee21 table has been created.

Right click on employee21 table and select Script followed by Insert Script.

Column details will appear.

Enter first record details and click on execute.

Enter second record details and click on execute.

Enter third record details and click on execute.

Enter fourth record details and click on execute.

Click on employee21 table and select View Data followed by View top 100 rows.

It display all the employee details of employee21 table.

Select statement is used to retrieve a desire value from the database tables.

In the SQLDB database, employee21 table has been created.

Right click on employee21 table and select Script followed by Select Script.

Display all the column name with the tablename and added where condition.

A specific employee records get displayed using select query.

By using update command, the column values can be updated.i.e, changing the name of the employee and increasing/decreasing the salary.

In the SQLDB database, employee21 table has been created.

Right click on employee21 table and select script followed by Update script.

It display the below window.

Updating the dept name value.

Right click on employee21 table and select View Data followed by View top 100 rows.

Here the dept name has been updated.

By using delete command one can delete the rows of an existing table based on the given condition.

In the SQLDB database ,employee21 table has been created.

Right click on employee21 and select script followed by delete script.

A new window is appeared with some condition.

Deleting the employee record from the employee21 table.

Right click on employee21 table select View Data followed by View Top 100 Rows.

Details of employee with emp_id=1002 has been successfully remove. 

• PostgreSQL Queries - Is a collection of variables of homogeneous data type.
• Insert - Inserting the values inside the database tables.
• Select - Retrieving a specific value from the database table.
• Update - Updating the values from the database table.
• Delete - Deleting a particular record from the database table.