[highgo@hg ~]$ cat a.sql
select * from test_a;
[highgo@hg ~]$ psql -f a.sql --psql连接时执行
Password:
id | name
----+------
1 | a
2 | b
3 | c
4 | d
5 | e
(5 rows)
[highgo@hg ~]$ psql
Password:
psql (3.1.4)
Type "help" for help.
highgo=# \i a.sql --psql命令提示符下执行
id | name
----+------
1 | a
2 | b
3 | c
4 | d
5 | e
(5 rows)
select * from test_a;
[highgo@hg ~]$ psql -f a.sql --psql连接时执行
Password:
id | name
----+------
1 | a
2 | b
3 | c
4 | d
5 | e
(5 rows)
[highgo@hg ~]$ psql
Password:
psql (3.1.4)
Type "help" for help.
highgo=# \i a.sql --psql命令提示符下执行
id | name
----+------
1 | a
2 | b
3 | c
4 | d
5 | e
(5 rows)