Appendix C. SQL primer

PostgreSQL supports almost the whole ANSI SQL 92, 1999 standard logic, as well as many of the SQL:2003, SQL:2006, SQL:2008 constructs, and some of the SQL:2011 constructs. In this appendix, we’ll cover some of these as well as some PostgreSQL-specific SQL language extensions. Because we’ll remain fairly focused on standard functionality, the content in this appendix is also applicable to other standards-compliant relational databases.

C.1. information_schema

The information_schema is a catalog introduced in SQL 92 and enhanced in each subsequent version of the spec. Although it’s a standard, sadly most commercial and open source databases don’t completely support it. We know that the following common databases do: PostgreSQL ...

Get PostGIS in Action, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.