YouTip

# PostgreSQL SELECT Statement The PostgreSQL SELECT statement is used to fetch 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 of 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 chapter (#), we have already inserted some data into the table `company`. Using the `*` symbol, we can read all the data from this table: tutorialdb=# SELECT * FROM company; ID NAME AGE ADDRESS SALARY JOIN_DATE ---- ---------- ----- ---------- ------- --------1 Paul 32 California 20000.0 2001-07-132 Allen 25 Texas 2007-12-133 Teddy 23 Norway 20000.04 Mark 25 Rich-Mond 65000.0 2007-12-135 David 27 Texas 85000.0 2007-12-13 We can also read specific fields `ID` and `NAME`: tutorialdb=# SELECT ID,NAME FROM company; id | name ----+------- 1 | Paul 2 | Allen 3 | Teddy 4 | Mark 5 | David(5 rows)