sql - PostgreSQL and queue commands -

sql - PostgreSQL and queue commands -

i know if there way quere queries. doing basic text matching in psql , each query (which saved in different script) takes 6 hours run. wondering if there way queue scripts?

for example;

my database called; "data"

my scipts called; cancer, heart, death

and doing following;

data; \i cancer; data; \i heart; data; \i death;

but have come every , check whether running or not etc doesn't seem efficient.

i new postgresql appreciate help.

this easiest/fastest solution can think of, should work case ;)

when using psql command line, can start

-f filename

where filename sql script. run query , send output stdout. can forwards file. set queries sql-file , got own queuing.

assuming might run linux, utilize screen have simple way leave session open when logging of night.

sql postgresql