-c 执行sql语句
-A 返回数据非对齐模式
-t 返回数据本身
-f 执行sql文件
-q 不显示输出信息
[root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -c "select * from myschema.o_ls_test;" Password for user pguser: rid | name | timeflag -----+------+---------------------------- 1 | aa | 2021-07-03 20:12:15.004507 3 | cc | 2021-07-03 20:12:45.117668 (2 rows) [root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -A -c "select * from myschema.o_ls_test;" Password for user pguser: rid|name|timeflag 1|aa|2021-07-03 20:12:15.004507 3|cc|2021-07-03 20:12:45.117668 (2 rows) [root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -At -c "select * from myschema.o_ls_test;" Password for user pguser: 1|aa|2021-07-03 20:12:15.004507 3|cc|2021-07-03 20:12:45.117668 [root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -At -c "select name from myschema.o_ls_test limit 1;" Password for user pguser: aa
执行sql文件
[root@s101 /home/centos]#psql -h localhost -p 5432 mydb pguser -f /var/lib/pgsql/13/test.sql Password for user pguser: INSERT 0 1