PostgreSQL – Check Your PostgreSQL Version
November 10, 2009 at 14:25 | In Postgresql | Leave a CommentTags: Linux, Postgresql
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
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.