Current script does this in sequence.
connect
pull data based on select
copy/import into PG
wait 30 secs
connect again.
I've turned on connection logging in PG and I noticed that I keep
seeing
LOG : connection received
statuses.
Which means that the script is connecting to the server every
Scott Mohnkern wrote:
Well, I've figured out how to put data into a sqlite database. I can
extract data from the command line, however, for the life of me, I just
can't find any good documentation on using Select.
What I'm trying to do:
SELECT name, size FROM filelist where uid=given value