Summary of USE commands for postgres database command line client Psql

1. Switch to Postgres user;

2. Enter: Psql, enter the client psql of PostgreSQL;

3.\l View all the current databases;

4.psql Database1 connected to database1 this database;

5. \dt View all the tables of the currently connected database (DATABASE1);

6. \d Table1 View the table structure of table table1;

Also: Modify a user's password in ubuntu:

1. Switch to the root account;

2. passwd account name;

3. Follow the instructions, enter a new password, complete the modification;

Summary of USE commands for postgres database command line client Psql