连接数据库: psql -U postgres -d beian_d -h localhost (psql -U user -d dbname) \c dbname 切换数据库,相当于mysql的use dbname \l 列举数据库,相当于mysql的show databases \dt 列举表,相当于show tables \d tblname 查看表结构,相当于desc tblname,show columns from tbname 退出postgres用户: exit