5.14. PostgreSQL SELECT statement

5.14.1. Grammar ¶

The syntax format of the SELECT statement is as follows:

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

Column1, column2,…columnN is the field name in the table.

Table_name is the table name.

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

SELECT * FROM table_name;

In the previous chapter INSERT INTO 语句 We have inserted some data into the table company, and use the* sign to read all the data in the table:

runoobdb=# 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 the specified fields ID and NAME:

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

In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress.