Postgres 的一些命令 mac下_qq_16924507的专栏-CSDN博客

来自 : CSDN技术社区 发布时间：2021-03-24

Postgres 的一些命令 mac下

TNT:~ rilintech$ psql -U postgres -h 127.0.0.1
进入postgresrilintech$ postgres # \\l
数据库listpostgres # \\c changhai_ibd_ios
You are now connected to database “changhai_ibd_ios” as user “postgres”.
4.changhai_ibd_ios # \\dt
List of relations
Schema | Name | Type | Owner
——– —————————- ——- ———-
public | crf_tables | table | postgres
public | crf_tables_menu_libs | table | postgres
public | diagnose_details | table | postgres
public | diagnose_specifications | table | postgres
public | diagnose_types | table | postgres
public | follow_ups | table | postgres
public | foreign_libs | table | postgres
public | groups | table | postgres
public | hospital_records | table | postgres
public | image_types | table | postgres
public | item_values | table | postgres
public | items | table | postgres
public | lib_certificate_type_infos | table | postgres
public | lib_configs | table | postgres
public | lib_groups | table | postgres
public | lib_languages | table | postgres
public | lib_nations | table | postgres
public | lib_publics | table | postgres
public | lib_role_groups | table | postgres
public | menu_libs | table | postgres
: 点赞 评论