The sample output shown here has been created with PostgreSQL's
psql utility, usually running on a Linux system. Most of the code will work the same way if you are using a GUI utility like
pgAdmin3 to access the server instead. When you see lines like this:
postgres=# SELECT 1;
postgres=# part is the prompt shown by the
Examples in this book have been tested using PostgreSQL 9.2. They will probably work on PostgreSQL version 8.3 and later. There have not been many major changes to how server programming happens in the last few versions of PostgreSQL. The syntax has become stricter over time to reduce the possibility of mistakes in server programming code. Due to the nature of those changes, most code ...