---

PostgreSQL SELECT explanation is utilized to get the information from a data set table, which returns information as result table. These outcome tables are called result-sets. 

Syntax

The essential punctuation of SELECT articulation is as per the following − 

SELECT column1, column2, columnN FROM table_name;

Here, column1, column2...are the fields of a table, whose qualities you need to bring. In the event that you need to bring all the fields accessible in the field, at that point you can utilize the accompanying language structure − 

SELECT * FROM table_name;

Example

Consider the table COMPANY having records as follows − 

 id | name  | age | address   | salary
----+-------+-----+-----------+--------
  1 | Paul  |  32 | California|  20000
  2 | Allen |  25 | Texas     |  15000
  3 | Teddy |  23 | Norway    |  20000
  4 | Mark  |  25 | Rich-Mond |  65000
  5 | David |  27 | Texas     |  85000
  6 | Kim   |  22 | South-Hall|  45000
  7 | James |  24 | Houston   |  10000
(7 rows)

Coming up next is a model, which would bring ID, Name and Salary fields of the clients accessible in CUSTOMERS table − 

testdb=# SELECT ID, NAME, SALARY FROM COMPANY ;

This would deliver the accompanying outcome − 

  id | name  | salary
 ----+-------+--------
   1 | Paul  |  20000
   2 | Allen |  15000
   3 | Teddy |  20000
   4 | Mark  |  65000
   5 | David |  85000
   6 | Kim   |  45000
   7 | James |  10000
(7 rows)

In the event that you need to bring all the fields of CUSTOMERS table, at that point utilize the accompanying question − 

testdb=# SELECT * FROM COMPANY;

This would create the accompanying outcome − 

 id | name  | age | address   | salary
----+-------+-----+-----------+--------
  1 | Paul  |  32 | California|  20000
  2 | Allen |  25 | Texas     |  15000
  3 | Teddy |  23 | Norway    |  20000
  4 | Mark  |  25 | Rich-Mond |  65000
  5 | David |  27 | Texas     |  85000
  6 | Kim   |  22 | South-Hall|  45000
  7 | James |  24 | Houston   |  10000
(7 rows)