RSS

Display PostgreSQL/PgSQL version

22 Jul

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

root@nikko[~]# psql –version
psql (PostgreSQL) 8.1.23
contains support for command-line editing

src: http://www.tech-recipes.com/rx/282/display-postgresqlpgsql-version/

 
Leave a comment

Posted by on July 22, 2011 in Computer, Database

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: