PostgreSQL operations-Basic psql commands and postgresql operations-psql

PostgreSQL operations-Basic psql commands and postgresql operations-psql

1. Establish a database connection
----------------
Access PostgreSQL database: psql-h IP address-p port-U Database Name

Enter the Database Password.

 

2. Access the database

1. List databases: \ l
2. Select Database: \ c Database Name
3. view all tables in a database: \ dt
4. Switch Database: \ c interface
5. view a table structure in a database: \ d table name
6. view the record of a table in a database: select * from apps limit 1;
7. display character set: \ encoding
8. Exit psgl: \ q