Re: How to insert from linux to postgreSQL - Mailing list pgsql-admin

From Frank Alberto Rodriguez
Subject Re: How to insert from linux to postgreSQL
Date
Msg-id a8419f27b80e56b93cd2e53a155b4e37125a9c67.camel@gmail.com
Whole thread Raw
In response to How to insert from linux to postgreSQL  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
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.

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

 

pgsql-admin by date:

Previous
From: "Peter M. Groen"
Date:
Subject: Re: How to insert from linux to postgreSQL
Next
From: arnab biswas
Date:
Subject: Postgresql.conf file not found after database restart.