centos8下postgreSQL入门3.2.2之psql执行

执行脚本

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