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