给个目标就上路

前行路上的精彩,只有在路上才能体会。

Views

3.2. Views Refer back to the queries in Section 2.6. Suppose the combined listing of weather records and city location is of particular interest to ...

2019-06-13 11:18:04

阅读数 346

评论数 0

Introduction

3.1. Introduction In the previous chapter we have covered the basics of using SQL to store and access your data in PostgreSQL. We will now discuss s...

2019-06-10 17:11:24

阅读数 271

评论数 0

Deletions

2.9.Deletions Rows can be removed from a table using the DELETE command. Suppose you are no longer interested in the weather of Hayward. Then you ca...

2019-06-10 16:17:20

阅读数 269

评论数 0

Updates

2.8.Updates You can update existing rows using the UPDATE command. Suppose you discover the temperature readings are all off by 2 degrees after Nove...

2019-06-10 13:51:10

阅读数 261

评论数 0

Aggregate Functions

2.7. Aggregate Functions Like most other relational database products, PostgreSQL supports aggregate functions. An aggregate function computes a sin...

2019-06-10 12:27:43

阅读数 26

评论数 0

Joins Between Tables

2.6. Joins Between Tables Thus far, our queries have only accessed one table at a time. Queries can access multiple tables at once, or access the sa...

2019-05-17 17:36:18

阅读数 43

评论数 0

Querying a Table

2.5. Querying a Table To retrieve data from a table, the table is queried. An SQL SELECT statement is used to do this. The statement is divided into...

2019-05-17 14:37:09

阅读数 25

评论数 0

Populating a Table With Rows

2.4. Populating a Table With Rows The INSERT statement is used to populate a table with rows: INSERT INTO weather VALUES ('San Francisco', 46, 50, ...

2019-05-16 17:14:09

阅读数 18

评论数 0

Creating a New Table

2.3. Creating a New Table You can create a new table by specifying the table name, along with all column names and their types: CREATE TABLE weathe...

2019-05-16 16:36:20

阅读数 22

评论数 0

Concepts

2.2. Concepts PostgreSQL is a relational database management system (RDBMS). That means it is a system for managing data stored in relations. Relati...

2019-05-16 15:20:41

阅读数 301

评论数 0

Introduction

2.1. Introduction This chapter provides an overview of how to use SQL to perform simple operations. This tutorial is only intended to give you an in...

2019-05-15 15:20:04

阅读数 266

评论数 0

Accessing a Database

1.4. Accessing a Database Once you have created a database, you can access it by: • Running the PostgreSQL interactive terminal program, called psq...

2019-05-15 14:25:07

阅读数 25

评论数 0

Creating a Database

1.3. Creating a Database The first test to see whether you can access the database server is to try to create a database. A running PostgreSQL ser...

2019-04-30 15:14:23

阅读数 75

评论数 0

Architectural Fundamentals

1.2. Architectural Fundamentals Before we proceed, you should understand the basic PostgreSQL system architecture. Understanding how the parts of Po...

2019-04-19 22:27:06

阅读数 41

评论数 0

Installation

1.1. Installation Before you can use PostgreSQL you need to install it, of course. It is possible that PostgreSQL is already installed at your site,...

2019-04-19 17:49:33

阅读数 595

评论数 0

Tutorial

Part I. Tutorial Welcome to the PostgreSQL Tutorial. The following few chapters are intended to give a simple introduction to PostgreSQL, relational...

2019-04-18 12:55:29

阅读数 714

评论数 0

Bug Reporting Guidelines

When you find a bug in PostgreSQL we want to hear about it. Your bug reports play an important part in making PostgreSQL more reliable because even t...

2019-04-18 11:08:22

阅读数 198

评论数 0

Further Information

Besides the documentation, that is, this book, there are other resources about PostgreSQL: Wiki The PostgreSQL wiki5 contains the project's FAQ6...

2019-04-17 11:00:52

阅读数 82

评论数 0

Conventions

The following conventions are used in the synopsis of a command: brackets ([ and ]) indicate optional parts. (In the synopsis of a Tcl command, quest...

2019-04-17 10:24:31

阅读数 524

评论数 0

A Brief History of PostgreSQL

The object-relational database management system now known as PostgreSQL is derived from the POSTGRES package written at the University of California...

2019-04-16 22:13:37

阅读数 78

评论数 0

提示
确定要删除当前文章?
取消 删除