Re: How to insert from linux to postgreSQL

[Scott Whitney <scott@xxxxxxxxxxx>]

Is the log file "ready" for INSERT, line by line? If not, you need to preprocess it. The 2 solutions I would use are psycopg for Python or sed + INSERT depending.

---

From: Ron <ronljohnsonjr@xxxxxxxxx>
Sent: Monday, April 8, 2019 2:18:18 PM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
Subject: Re: How to insert from linux to postgreSQL

 

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.

Scott Whitney Director of IT scott@xxxxxxxxxxx | +1 (800) 755-9878 7600 Burnet Road, Ste. 300 Austin, TX 78757 Visit us at www.journyx.com

To unsubscribe from Journyx promotional emails, click here or visit http://journyx.com/communication-preferences.