执行脚本
psql -f {脚本文件路径}
脚本文件路径的选择
参考
https://wiki.postgresql.org/wiki/YUM_Installation#Install_PGDG_Repo_RPM_and_PostgreSQL
Data Directory
The PostgreSQL data directory contains all of the data files for the database. The variable PGDATA is used to reference this directory.
The default data directory is:
/var/lib/pgsql/<name>/data
For example:
/var/lib/pgsql/12/data
在 /var/lib/pgsql/ 下创建脚本文件夹
cd /var/lib/pgsql
mkdir my_scripts