5. Postgresql

  • 5.1. PostgreSQL tutorial

    PostgreSQL is a free object-relational database server (ORDBMS) distributed under a flexible BSD license. PostgreSQL ...
    2025-10-25 13:32:25 UTC
  • 5.2. Install PostgreSQL on Linux

    Open the PostgreSQL website https://www.postgresql.org/ and click on the menu bar Download You can see that there are in...
    2025-10-25 13:32:26 UTC
  • 5.3. Install PostgreSQL on Windows

    EnterpriseDB is used here to download and install, and EnterpriseDB is the only vendor in the world that offers enterprise-c...
    2025-10-25 13:32:22 UTC
  • 5.4. Install PostgreSQL on Mac OS

    Using EnterpriseDB to download and install, EnterpriseDB is the only vendor in the world that offers PostgreSQL-based enterp...
    2025-10-25 13:32:24 UTC
  • 5.5. PostgreSQL syntax

    By default, when PostgreSQL is installed, it comes with a command line tool SQL Shell(psql) . Linux The system can swi...
    2025-10-25 13:32:28 UTC
  • 5.6. PostgreSQL data type

    In this section, we will discuss the data types of PostgreSQL, which we set for each field when we created the table. Bene...
    2025-10-25 13:32:22 UTC
  • 5.7. PostgreSQL creates a database

    PostgreSQL can create a database in the following three ways: 1、使用 CREATE DATABASE SQL 语句来创建。 2、使用 createdb 命令来创建。 ...
    2025-10-25 13:32:26 UTC
  • 5.8. PostgreSQL Select Database

    In the previous section, we talked about how to create a database, and then we discussed how to select the database we creat...
    2025-10-25 13:32:27 UTC
  • 5.9. PostgreSQL deletes the database

    PostgreSQL can delete a database in the following three ways: 1、使用 DROP DATABASE SQL 语句来删除。 2、使用 dropdb 命令来删除。 3...
    2025-10-25 13:32:27 UTC
  • 5.11. PostgreSQL delete table

    PostgreSQL uses DROP TABLE statements to delete tables, including table data, rules, triggers, and so on, so be careful to d...
    2025-10-25 13:32:25 UTC
  • 5.12. PostgreSQL mode (SCHEMA)

    The PostgreSQL schema (SCHEMA) can look like a collection of tables. A schema can contain views, indexes, data types, func...
    2025-10-25 13:32:22 UTC
  • 5.13. PostgreSQL INSERT INTO statement

    The PostgreSQL INSERT INTO statement is used to insert new records into the table. We can insert one row or multiple rows ...
    2025-10-25 13:32:27 UTC
  • 5.14. PostgreSQL SELECT statement

    The PostgreSQL SELECT statement is used to select data from the database. The results are stored in a result table called ...
    2025-10-25 13:32:24 UTC
  • 5.15. PostgreSQL operator

    An operator is a symbol that tells the compiler to perform a specific mathematical or logical operation. The PostgreSQL op...
    2025-10-25 13:32:24 UTC
  • 5.17. PostgreSQL WHERE clause

    In PostgreSQL, when we need to query data from a single table or multiple tables according to specified conditions, we can a...
    2025-10-25 13:32:23 UTC
  • 5.18. PostgreSQL AND & OR operator

    In PostgreSQL, AND and OR, also known as join operators, are used to narrow the scope of a query when querying data, and we ...
    2025-10-25 13:32:23 UTC
《地理信息系统原理、技术与方法》  97

最近几年来,地理信息系统无论是在理论上还是应用上都处在一个飞速发展的阶段。 GIS被应用于多个领域的建模和决策支持,如城市管理、区划、环境整治等等,地理信息成为信息时代重要的组成部分之一; “数字地球”概念的提出,更进一步推动了作为其技术支撑的GIS的发展。 与此同时,一些学者致力于相关的理论研究,如空间感知、空间数据误差、空间关系的形式化等等。 这恰好说明了地理信息系统作为应用技术和学科的两个方面,并且这两个方面构成了相互促进的发展过程。