On 4/8/19 2:03 PM, Campbell, Lance wrote:
PostgreSQL 10.x
Use case:
I want to read a log file on my linux server and write each line out to a row in a postgreSQL table.
Presumably some manipulations need to be performed so that you can't just do COPY FROM STDIN?
When I do inserts however I want to make sure I am using prepared statements to avoid SQL injections. I know how to do this is Java but I have not found an example using a linux bash scripts.
Does anyone have an example they could point me to?
I think the problem is that you need an open connection to use prepared statements, and you can't do that in bash. What about using Python? (After all, that's a scripting language, too.)
--
Angular momentum makes the world go 'round.