Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hyLSb-0003Qk-Bj for pgsql-docs@arkaria.postgresql.org; Thu, 15 Aug 2019 19:30:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hyLSa-0004d5-3L for pgsql-docs@arkaria.postgresql.org; Thu, 15 Aug 2019 19:30:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hyLSZ-0004bT-Ml for pgsql-docs@lists.postgresql.org; Thu, 15 Aug 2019 19:30:55 +0000 Received: from mail-pf1-x42a.google.com ([2607:f8b0:4864:20::42a]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hyLSQ-0007GZ-8t for pgsql-docs@postgresql.org; Thu, 15 Aug 2019 19:30:54 +0000 Received: by mail-pf1-x42a.google.com with SMTP id q139so1795586pfc.13 for ; Thu, 15 Aug 2019 12:30:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=commandprompt-com.20150623.gappssmtp.com; s=20150623; h=to:from:subject:organization:message-id:date:user-agent :mime-version:content-language; bh=kqvi2R7DCnHHZP/G/iEvlFUeqyJyn9C2iFyOrbt7Hws=; b=j8RWwF3yq0OnzDX7fslN2BcQQ6CCFG63DpYiAW7Lqq1fHGtlAP90/V3aRLTrbEkFIh vaCKPfLTyK2FoUzp+FpOYu0qnSQeNthZ4SaU78vmVhz0kKhknKmw+fLjEVz2uGb+igHW m8HuT/YApURJFm8TJTd6Z/6fa4oxYA7GXWMEg88YNlXMK84hCRhbp52mewVzB/TaOqTl FDfnKEG3pJiiFrCL4bY+isfUQCDScVd6dwchk3tbsltXa74xnWk4QH2tyckGtc4AIf8K ltyqmnqK4o66hEo9PVB0b9nj7vDn0u7u5FVtgoKRZd1+XcWYWyBou23iX5A28Fw+vl9m oiWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:to:from:subject:organization:message-id:date :user-agent:mime-version:content-language; bh=kqvi2R7DCnHHZP/G/iEvlFUeqyJyn9C2iFyOrbt7Hws=; b=abAVnQKgwzSizI/+JAZXKcR14pZl3c7tZkJya3njoUy5BrIRdcrUrJfM+Kab1tlN7V xxEoO8zhnu1H69JT4jAVORfYzrschlNgbugArJdyL/qfnYfxxAHcyt5jep295Xg2uL0F OMa6CTsqJPz1NSU/udt12r3vYo0z+JkF1uXp5UidJY2s9FA9tP05JuaVT1NeUSBOI2gt Uh58TRsilFe+y0noF8M0tBf/AdIe6CpHvvPtt84RrXAVfDX21OwTqaUebktTQC6XPPBk CAaU1HS7IRFoEhJ0NZ0BajCehBvozKf39w9H5uFALPTSKTSXRjemBqqGLS8+FKkhx5xp UYyA== X-Gm-Message-State: APjAAAUeWq4/cwTMo4vZBF651La/aq37muQhHwSvWeTSAb2h/raRhtWr jsySvWFibdvDwt4rKa3O/m9EA1aFBAazI0lU93TyculkQOyyuc74l924gucaNjd9et9m8x4I4Kp x3MypbZ8FH0VGPcJpThbLtykwMSq3hvLbYE35jMmbZH+n0b1eW9x4DVss6orIuCjAdUN+eWg= X-Google-Smtp-Source: APXvYqz5NfQMDJyHExfrHIuEhyDLB/aPZu3y7hTu29EvN01kpAB/+uESgVGrFbY2UKfDwvYoHfhc8A== X-Received: by 2002:aa7:98da:: with SMTP id e26mr7027711pfm.34.1565897442121; Thu, 15 Aug 2019 12:30:42 -0700 (PDT) Received: from ?IPv6:2600:100f:b01c:7020:d964:953c:db44:cc3b? ([2600:100f:b01c:7020:d964:953c:db44:cc3b]) by smtp.gmail.com with ESMTPSA id k64sm3141832pge.65.2019.08.15.12.30.28 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 15 Aug 2019 12:30:41 -0700 (PDT) To: pgsql-docs From: "Joshua D. Drake" Subject: readability changes to postgres.sgml Organization: Command Prompt, Inc. Message-ID: <5ac2c96d-37a6-18aa-08c4-327a6fbff24b@commandprompt.com> Date: Thu, 15 Aug 2019 12:30:17 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------3901F2B6148707242C0E4905" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------3901F2B6148707242C0E4905 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit attached Thanks, JD -- Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: @amplifypostgres || Get help: https://commandprompt.com/ ***** Unless otherwise stated, opinions are my own. ***** --------------3901F2B6148707242C0E4905 Content-Type: text/x-patch; name="postgres.diff" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="postgres.diff" diff --git a/doc/src/sgml/postgres.sgml b/doc/src/sgml/postgres.sgml index e59cba7997..9f78a62ed8 100644 --- a/doc/src/sgml/postgres.sgml +++ b/doc/src/sgml/postgres.sgml @@ -31,24 +31,22 @@ Welcome to the PostgreSQL Tutorial. The - following few chapters are intended to give a simple introduction + tutorial is intended to give an introduction to PostgreSQL, relational database - concepts, and the SQL language to those who are new to any one of - these aspects. We only assume some general knowledge about how to - use computers. No particular Unix or programming experience is - required. This part is mainly intended to give you some hands-on - experience with important aspects of the - PostgreSQL system. It makes no attempt - to be a complete or thorough treatment of the topics it covers. + concepts, and the SQL language. We assume some general knowledge about + how to use computers and no particular Unix or programming experience is + required. This tutorial is intended to provide hands-on experience with + important aspects of the PostgreSQL system. + It makes no attempt to be a comprehensive treatment of the topics it covers. - After you have worked through this tutorial you might want to move - on to reading to gain a more formal knowledge + After you have successfully completed this tutorial you will want to + read the section to gain a better understanding of the SQL language, or for - information about developing applications for - PostgreSQL. Those who set up and - manage their own server should also read . + information about developing applications with + PostgreSQL. Those who provision and + manage their own PostgreSQL installation should also read . @@ -66,28 +64,26 @@ This part describes the use of the SQL language in PostgreSQL. We start with describing the general syntax of SQL, then - explain how to create the structures to hold data, how to populate - the database, and how to query it. The middle part lists the - available data types and functions for use in - SQL commands. The rest treats several - aspects that are important for tuning a database for optimal - performance. + how to create tables, how to populate the database, and how to + query it. The middle part lists the available data types and + functions for use in SQL commands. Lasty, + we address several aspects of importantance for tuning a database. - The information in this part is arranged so that a novice user can - follow it start to end to gain a full understanding of the topics + The information is arranged so that a novice user can + follow it from start to end and gain a full understanding of the topics without having to refer forward too many times. The chapters are intended to be self-contained, so that advanced users can read the - chapters individually as they choose. The information in this - part is presented in a narrative fashion in topical units. - Readers looking for a complete description of a particular command - should see . + chapters individually as they choose. The information is presented + in narrative form with topical units. Readers looking for a complete + description of a particular command are encouraged to review + the . - Readers of this part should know how to connect to a - PostgreSQL database and issue + Readers should know how to connect to a + PostgreSQL database and issue SQL commands. Readers that are unfamiliar with these issues are encouraged to read first. SQL commands are typically entered @@ -118,32 +114,32 @@ This part covers topics that are of interest to a - PostgreSQL database administrator. This includes - installation of the software, set up and configuration of the - server, management of users and databases, and maintenance tasks. - Anyone who runs a PostgreSQL server, even for + PostgreSQL administrator. This includes + installation, configuration of the server, management of users + and databases, and maintenance tasks. Anyone running + PostgreSQL server, even for personal use, but especially in production, should be familiar - with the topics covered in this part. + with these topics. - The information in this part is arranged approximately in the - order in which a new user should read it. But the chapters are - self-contained and can be read individually as desired. The - information in this part is presented in a narrative fashion in - topical units. Readers looking for a complete description of a - particular command should see . + The information attempts to be in the order in which + a new user should read it. The chapters are self-contained and + can be read individually as desired. The information is presented + in a narrative form in topical units. Readers looking for a complete + description of a command are encouraged to review the + . The first few chapters are written so they can be understood without prerequisite knowledge, so new users who need to set - up their own server can begin their exploration with this part. - The rest of this part is about tuning and management; that material + up their own server can begin their exploration. The rest of this + part is about tuning and management; that material assumes that the reader is familiar with the general use of the PostgreSQL database system. Readers are - encouraged to look at and for additional information. + encouraged review the and parts for additional information. @@ -174,13 +170,13 @@ This part describes the client programming interfaces distributed with PostgreSQL. Each of these chapters can be - read independently. Note that there are many other programming - interfaces for client programs that are distributed separately and + read independently. There are many extrernal programming + interfaces for client programs that are distributed separately. They contain their own documentation ( lists some of the more popular ones). Readers of this part should be - familiar with using SQL commands to manipulate + familiar with using SQL to manipulate and query the database (see ) and of course - with the programming language that the interface uses. + with the programming language of their choice. @@ -198,15 +194,15 @@ This part is about extending the server functionality with user-defined functions, data types, triggers, etc. These are - advanced topics which should probably be approached only after all + advanced topics which should be approached only after all the other user documentation about PostgreSQL has been understood. Later chapters in this part describe the server-side programming languages available in the PostgreSQL distribution as well as - general issues concerning server-side programming languages. It + general issues concerning server-side programming. It is essential to read at least the earlier sections of (covering functions) before diving into the - material about server-side programming languages. + material about server-side programming. --------------3901F2B6148707242C0E4905--