postgresql 导入 sql 报错 GBK UTF8

问题描述：postgresql 导入 sql 后缀文件失败 Permission denied

Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
用户 postgres 的口令：
psql (12.3)
输入 "help" 来获取帮助信息.

postgres=# \i C:\Users\input\Desktop\public-test.sql
C:: Permission denied

错误：character with byte sequence 0xaf 0xa6 in encoding “GBK” has no equivalent in encoding “UTF8”

推测原因：编码方式不一致

实际原因：客户端编码与服务端编码不一致

postgres=# select name,setting,context from pg_settings where name like '%encoding%';
      name       | setting | context
-----------------+---------+----------
 client_encoding | GBK     | user
 server_encoding | UTF8    | internal
(2 行记录)

解决方案：修改客户端编码方式和服务端一致

\encoding UTF8