echo echo "===================== Basics of psql Interface ( Postgres SQL) ====================" echo " $ psql --u username : to login to psql, and password is needed." echo echo " username=# : This is psql promput" echo echo " When you see the prompt above,you have login to Pregres SQL DBMS" echo " successfully. You type any SQL commands or any following command for help" echo echo " \help : to list all SQL, psql commands." echo " \copyright : for distribution terms" echo " \h : for help with SQL commands" echo " \? : for help with psql commands" echo " \! os_command : to execute a operating system command." echo " \c user-or-db-name : conect to a different user/dbname." echo " \i filename : execute command in filename" echo " \q : to quit psql-interfae." echo echo " -----------------------------------------------------------------------------" echo " Some commonly used psql commands:" echo " \dt \dv \df : show tables, views, functions," echo " \dp : table-view-sequences. " echo " \d tablename : show table attributes, indexes and column and table" echo " constraints." echo " \o fileName : save all display or output of psql command into the" echo " named file.If no file name followed \o, display will." echo " be one screen." echo " gradebook=# SELECt * FROM students; to list records of all stutents." echo " =============================================================================="