Hello all,
I am using a laptop and some of my .sql files with
insert statements (300K insert statements) take very
long time.
I user
database=> \i /home/user/../../../insert.sql
this takes a long time. and if i shutdown my laptop,
the server connection is lost . I am using Putty to
connect to my server.
Could any one help to setup a background job where I
can start a job and forget until the next morning to
see that the job is finished.
Should it be something like the following:
myserver$ psql -d mydb -d node2|\i /insert.sql &>
this command is WRONG. Can any one help me with a
correct one.
Thank you
K
________________________________________________________________________
Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/