Postgres 的一些命令 mac下
- TNT:~ rilintech$ psql -U postgres -h 127.0.0.1
进入postgres - rilintech$ postgres=# \l
数据库list - postgres=# \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
: