POSTGRESQL | POSTGRSQL COMMANDS AND VERSIONS | POSTGRESQL DOWNLOAD

POSTGRESQL

Developed By- PostgreSQL Global Development Group.
Initial Release Date-08/07/1996.
Written In- C Language.



          PostgreSQL is an free open source relational database management system. and it is a powerful, open source object-relational database system.  PostgreSQL developed by PostgreSQL Global Development Groups. It runs on many platforms like Linux ,UNIX , Mac OS X , Solaris , Windows etc. It supports text, images, sounds, and video, and includes programming interfaces for C / C++ , Java , Perl , Python , Ruby, Open Database Connectivity.


PostgreSQL have many features aimed to help developers build the best applications, and help you manage your data no matter how big or small the dataset or what quality of data. In addition it is free and open source, PostgreSQL is highly extensible. and it is very fast.

PostgreSQL has been proven to be highly scalable and extensible both are quantity of data it can manage and in the number of concurrent users it can accommodate.

 POSTGRESQL versions -

• postgreSQL 6.0  release date - 29-01-1997                            
• postgreSQL 6.1  release date - 08-06-1997                               
• postgreSQL 6.2  release date - 02-10-1997                                   
• postgreSQL 6.3  release date - 01-03-1998                                  
• postgreSQL 6.4  release date - 30-10-1998                                 
• postgreSQL 6.5  release date -  09-06-1999                                  
• postgreSQL 7.0  release date - 08-05-2000                                    
• postgreSQL 7.1  release date - 13-04-2001                                 
• postgreSQL 7.2  release date - 04-02-2002                                 
• postgreSQL 7.3  release date - 17-11-2002                                
• postgreSQL 7.4  release date - 17-11-2003                          
• postgreSQL 8.0  release date - 19-01-2005                                 
• postgreSQL 8.1  release date - 08-11-2005                                
• postgreSQL 8.2  release date - 05-12-2006                          
• postgreSQL 8.3  release date - 04-02-2008                                   
• postgreSQL 8.4  release date - 01-07-2009                              
• postgreSQL 9.0  release date - 20-09-2010                             
• postgreSQL 9.1  release date - 12-09-2011                                
• postgreSQL 9.2  release date - 09-09-2013                             
• postgreSQL 9.3  release date - 03-10-2019                              
• postgreSQL 9.4  release date - 18-12-2014                               
• postgreSQL 9.5  release date - 07-01-2016                                 
• postgreSQL 9.6  release date -  29-09-2016                             
• postgreSQL 10 release date - 05-10-2017                                   
• postgreSQL 11  release date - 18-10-2018                                
• postgreSQL 12  release date - 03-10-2019.

postgresql commands -

dbname=> \q   --to quit

dbname=> \c database   --to connect to a different database

dbname=> \pset pager  --use to  on/off whether a screen pager is used for long output

dbname=> \d   --to describe list tables are in the database

dbname=> \d table   --to describe attributes of a table

dbname=> \i filename  --to run (include) a script file of SQL commands

dbname=> \e filename  --to edit an existing script and execute the commands

dbname=> \e  --to edit the last SQL command and execute upon exit

dbname=> \w filename  --to write the last SQL command to a file

dbname=> \?  --show the list of postgres commands

dbname=> \h  --show the list of sql commands


dbname=> \h command    --show syntax