Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. # Start psql
  2. psql -h localhost -U <user-name> -d <database-name>
  3.  
  4. # List all databases
  5. \l or \list
  6.  
  7. # List all tables in the current database
  8. \dt *.
  9.  
  10. # To switch databases
  11. \connect <database-name> or \c <database-name>
  12.  
  13. # Expanded display on/off
  14. \x
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement