Friday, May 22, 2020

The psql command

1. Use to psql command to start using postgres commands



2. Use \h to view all sql commands



3. Use the \h option followed by a command to learn how to use such command



4. Use \? to view all postgres commands


5.  Type \l+ to check the sizes of the databases



6. Connect to the vCenter database and verify connectivity



7.  Use \dt to list all tables



8. Use \z to view all tables, views and sequences



9. Use the following command to view the size of a particular table


10. Use \du to view all users and their roles



11 . Use \s to view previously executed commands


12.  Use \q to quit




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.