The SQL Guide to Pervasive PSQL - first edition

Scheduled EventsEvent outlinesBooksWhitepapersWebinarsArticlesContact UsRick F van der Lans



Support independent publishing: buy this book on Lulu.



[Home][Books][Pervasive PSQL]



The Most Complete and Practical SQL Guide to Pervasive PSQL Version 10


Pervasive PSQL is probably not the most well-known database server, but is definitely one of the most used database servers. Hundreds of business applications, inclusing inventory control systems and bookkeeping systems, have been developed using Pervasive PSQL. This book describes Pervasive PSQL in detail.


For more than twenty years, van der Lans's Introduction to SQL, has been one of the most popular books on SQL. Thousands and thousands of IT professionals have learned SQL programming from his book. The SQL Guide for Pervasive PSQL is his latest book. All the typical Pervasive PSQL features are being discussed in detail. So, it is not a generic book on SQL, it is a book on the Pervasive PSQL database server, including descriptions of all the new features.


With hundreds of examples, plus a proven approach and structure, the book teaches you how to use Ingres efficiently and effectively. It contains a complete description of the SQL dialect as implemented in Pervasive PSQL version 10. The book can be seen as a tutorial and a reference book.

Learn how to:

  • Query and update data
  • Create and restructure databases, tables, views, and indexes
  • Specify primary keys and foreign keys
  • Develop stored procedures, stored functions, and triggers
  • Decouple tables from files
  • Access data in the DDF files
  • Work with character sets and collations

Target audience: This book is intended for all developers and students using the Pervasive PSQL database server. From developers of small organizations responsible for developing applications using Pervasive PSQL, up to developers working for large corporations. Everyone will learn from this book. In short, if you use Pervasive PSQL, this book is for you!

Downloading The SQL Statements


All the SQL statements of the examples and exercises can be downloaded here. Instead of having a separate file for each chapter (as described in the book), we have created one file that contains the statements for all the chapters. This makes downloading easier.


Downloading SQL code for Restoring the Original Sample Database


If you want to restore the sample database to its original structure, download this file, and execute the SQL statements. The tables you have already created will be dropped, and new tables will be created.


Copyright (c) 2017 R20/Consultancy B.V.. All rights reserved.