PostgreSQL SELECT Statement

The PostgreSQL SELECT statement is used to select data from a database.

The result is stored in a result table, called the result set.

Syntax

The syntax for the SELECT statement is as follows:

SELECT column1, column2,...columnN FROM table_name;

• column1, column2,...columnN are the field names in the table.
• table_name is the name of the table.

If we want to read all the data from the table, we can use the following SQL statement:

SELECT * FROM table_name;

In the previous section INSERT INTO Statement, we have already inserted some data into the table company. Using the * symbol, we can read all the data from this table:

tutorialprodb=# SELECT * FROM company;

ID        NAME        AGE        ADDRESS     SALARY   JOIN_DATE
----      ----------  -----      ----------  -------      --------
1         Paul        32         California  20000.0      2001-07-13
2         Allen       25         Texas                    2007-12-13
3         Teddy       23         Norway      20000.0
4         Mark        25         Rich-Mond   65000.0      2007-12-13
5         David       27         Texas       85000.0      2007-12-13

We can also read specific fields, such as ID and NAME:

tutorialprodb=# SELECT ID,NAME FROM company;
 id | name  
----+-------
  1 | Paul
  2 | Allen
  3 | Teddy
  4 | Mark
  5 | David
(5 rows)