Display PostgreSQL/PgSQL version

Posted December 17, 2003 by Rex in PostgreSQL PgSQL


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.