Display PostgreSQL/PgSQL version

To display the PostgreSQL version number (and other information like compiler version used to build PgSQL) issue the following SQL statement from within psql:

SELECT version();

To quickly determine just the PostgreSQL version number, run this command from the OS command line:

psql --version

The Conversation

Follow the reactions below and share your own thoughts.

Leave a Reply