What version is the server?

If you experience problems, then you'll need to double-check which version of the server you have. This will help you to report a fault or to consult the correct version of the manual.

How to do it...

We will find out the version by directly querying the database server:

1. Connect to the database and issue the following command:

postgres # SELECT version();

2. You'll get a response that looks something like this:

PostgreSQL 10.2 on x86_64-apple-darwin16.7.0,
 compiled by Apple LLVM version 9.0.0 (clang-900.0.39.2), 64-bit

That's probably too much information all at once!

How it works...

...