Psql
Remote Login
psql -h 192.168.168.71 -U postgres
Local Login
psql -h localhost -U postgres
Show databases
\list
Switch to a database
\c $database
Show all tables
\dt
Select all from table
select * from users;
psql -h 192.168.168.71 -U postgres
psql -h localhost -U postgres
\list
\c $database
\dt
select * from users;