PostgreSQL – Check Your PostgreSQL Version

November 10, 2009 at 14:25 | In Postgresql | Leave a Comment
Tags: ,

Operating System: Gentoo Linux

To check your PostgreSQL version, simple enter the login to psql
psql -U <username> -d <dbname>

Linux ~ # psql -U kit -d kit_db
Password for user kit:
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

kit2=> select version();
                                                    version
----------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.6 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 4.1.2 (Gentoo 4.1.2 p1.0.2)
(1 row)

kit=>

The version is shown in the welcome statement. You can also find more details by entering select version();

Done =)

No Comments Yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.