Re: How to insert from linux to postgreSQL

[Frank Alberto Rodriguez <franknigth@xxxxxxxxx>]

Then why not using java? Just exec the .jar with the terminal params and do de job in java, or read a configuration file.

Or you could use PL/java.

https://tada.github.io/pljava/

Greetings

On Mon, 2019-04-08 at 19:03 +0000, 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.  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?

 

Thanks,

 

Lance