Re: How to insert from linux to postgreSQL

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
>
>
>
>