1# Install postgres
2sudo apt-get update
3sudo apt-get -y install postgresql
4
5sudo su - postgres
6psql
7
8for connection info : \conninfo
9for password : \password
10
11for roles : \du
12for database : \l
13for relation : \d
14for table : \dt
1PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development phase and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
2
3This tutorial will give you a quick start with PostgreSQL and make you comfortable with PostgreSQL programming.
4
5What is PostgreSQL?
6PostgreSQL (pronounced as post-gress-Q-L) is an open source relational database management system (DBMS) developed by a worldwide team of volunteers. PostgreSQL is not controlled by any corporation or other private entity and the source code is available free of charge.
1Fun fact: "Postgres" has exactly as many characters as "Database"
2Check for yourself!
3Postgres --> 8 chars!
4Database --> 8 chars!