PostgreSQL

POSTGRESQL

aptitude search postgresql

You have to install server type & latest version of SQL server.

Run postgresql command

apt-get install postgresql name ( package name with version )
                       or
aptitude install package name

After that we check postgresql is working or not
"psql : FATAL: role "root" does not exits

# psql postgres

# su - postgres

# pwd to check path of file.
    /var/lib/postgresql

#postgres@common-...:~$ su - postgres
#createuser -U postgres -P

Connect to database or access any database

#psql postgres ( database name )
postgres =>  [ postgres is bydefault database create when we install postgresql ]

To see database "\l"
To quit to database "\q"
Create database in postgresql
#createdb data1 ( database name ) ---> This command run in user mode.

postgres => CREATE DATABASE data1;
postgres => \l
Stop any process in sql ";"

Connect to other database
psqlgres => \c [ database name ] data1

Alt + F1 : open application menu
Alt + F2 : Display run application dialog
print screen : Take a screen shot of the entire desktop
Alt + print screen : Take a screen shot of the current open windows 
Ctrl + Alt + Arrow : switch to the work space to the specified direction of
                                 the current workspace.
Ctrl + Alt + D :  Minimize all windows & give focus to the desktop
Alt + tab : Switch between windows. A list of windows that you can select is display id. Release the keys to select a windows. You can press the "shift" key to cycle through the windows in reverse order.
Ctrl + Alt + Tab : Switch the focus between the panels and the desktop. A list of                              items that you can select it display. Release the keys to select
                             on item. you can press the "shift" key to cycle through
                             the  items in reverse order.