postgresql数据库系列之：cmd命令行访问远程postgresql数据库

postgresql数据库系列之：cmd命令行访问远程postgresql数据库

psql -h 10.129.88.141 -U iris_read -d iris_test
Password for user iris_read:
psql (9.5.17)
Type "help" for help.

查询数据

iris_test=# select * from pg_tables;
     schemaname     |        tablename        | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity
--------------------+-------------------------+------------+------------+------------+----------+-------------+-------------
 public             | subjects                | postgres   |            | f          | f        | f           | f
 pg_catalog         | pg_statistic            | postgres   |            | t          | f        | f           | f