2
PostgreSQL学习笔记
5墨值下载
PostgreSQL
Notes for Professionals
PostgreSQL
®
Notes for Professionals
GoalKicker.com
Free Programming Books
Disclaimer
This is an unocial free book created for educational purposes and is
not aliated with ocial PostgreSQL® group(s) or company(s).
All trademarks and registered trademarks are
the property of their respective owners
60+ pages
of professional hints and tricks
Contents
About 1 ...................................................................................................................................................................................
Chapter 1: Getting started with PostgreSQL 2 ..................................................................................................
Section 1.1: Installing PostgreSQL on Windows 2 ...........................................................................................................
Section 1.2: Install PostgreSQL from Source on Linux 3 ...............................................................................................
Section 1.3: Installation on GNU+Linux 4 .........................................................................................................................
Section 1.4: How to install PostgreSQL via MacPorts on OSX 5 ...................................................................................
Section 1.5: Install postgresql with brew on Mac 7 ........................................................................................................
Section 1.6: Postgres.app for Mac OSX 7 ........................................................................................................................
Chapter 2: Data Types 8 ...............................................................................................................................................
Section 2.1: Numeric Types 8 ...........................................................................................................................................
Section 2.2: Date/ Time Types 8 ....................................................................................................................................
Section 2.3: Geometric Types 9 .......................................................................................................................................
Section 2.4: Network Adress Types 9 .............................................................................................................................
Section 2.5: Character Types 9 .......................................................................................................................................
Section 2.6: Arrays 9 .........................................................................................................................................................
Chapter 3: Dates, Timestamps, and Intervals 11 .............................................................................................
Section 3.1: SELECT the last day of month 11 ...............................................................................................................
Section 3.2: Cast a timestamp or interval to a string 11 ..............................................................................................
Section 3.3: Count the number of records per week 11 ...............................................................................................
Chapter 4: Table Creation 12 .....................................................................................................................................
Section 4.1: Show table definition 12 ...............................................................................................................................
Section 4.2: Create table from select 12 ........................................................................................................................
Section 4.3: Create unlogged table 12 ...........................................................................................................................
Section 4.4: Table creation with Primary Key 12 ..........................................................................................................
Section 4.5: Create a table that references other table 13 ..........................................................................................
Chapter 5: SELECT 14 ......................................................................................................................................................
Section 5.1: SELECT using WHERE 14 .............................................................................................................................
Chapter 6: Find String Length / Character Length 15 ...................................................................................
Section 6.1: Example to get length of a character varying field 15 .............................................................................
Chapter 7: COALESCE 16 ...............................................................................................................................................
Section 7.1: Single non null argument 16 ........................................................................................................................
Section 7.2: Multiple non null arguments 16 ..................................................................................................................
Section 7.3: All null arguments 16 ...................................................................................................................................
Chapter 8: INSERT 17 ......................................................................................................................................................
Section 8.1: Insert data using COPY 17 ...........................................................................................................................
Section 8.2: Inserting multiple rows 18 ...........................................................................................................................
Section 8.3: INSERT data and RETURING values 18 .....................................................................................................
Section 8.4: Basic INSERT 18 ...........................................................................................................................................
Section 8.5: Insert from select 18 ....................................................................................................................................
Section 8.6: UPSERT - INSERT ... ON CONFLICT DO UPDATE.. 19 ................................................................................
Section 8.7: SELECT data into file 19 ..............................................................................................................................
Chapter 9: UPDATE 21 ....................................................................................................................................................
Section 9.1: Updating a table based on joining another table 21 ................................................................................
Section 9.2: Update all rows in a table 21 ......................................................................................................................
Section 9.3: Update all rows meeting a condition 21 ...................................................................................................
Section 9.4: Updating multiple columns in table 21 ......................................................................................................
of 74
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论