Guest User

Untitled

a guest
Oct 4th, 2018
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. psql "dbname=connPGdb host=localhost user=ycPgUser password=ycPgSecret port=5432"
  2. psql "dbname=sessionDB host=localhost user=ycPgUser password=ycPgSecret port=5432"
  3.  
  4. to list all database
  5. \l
  6.  
  7. to select a database
  8. \c sessiondb
  9.  
  10. to display all tables in public
  11. \dt
  12.  
  13. to get all tables in default_schema
  14. \dt local_schema.*
Add Comment
Please, Sign In to add comment