Display PostgreSQL/PgSQL version

Contributor Icon Contributed by Rex Date Icon December 17, 2003  
Tag Icon Tagged: 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

Previous recipe | Next recipe |
 

 
close Reblog this comment
blog comments powered by Disqus