Thanks for the pointers Adrian, got the records identified and ready to update, however scripting this, the script just halts at:
postgres@servername:~$
and does not process the next commands, below is what I have in the .sh file, would I need a prefix before the psql commands?
su - postgres...