Postgres Pro
Downloads
Home   >   mailing lists

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

From Rui DeSousa
Subject Re: How to insert from linux to postgreSQL
Date
Msg-id 80D01A64-24BA-420D-B963-2F8BCDA8AA7D@crazybean.net
Whole thread Raw
In response to How to insert from linux to postgreSQL  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
Tree view
I would use psql \copy command within a shell script or just not use it.  

Personally, I would choose Perl or GoLang if it requires parsing the data before inserting.  



On Apr 8, 2019, at 3:03 PM, Campbell, Lance <lance@illinois.edu> 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: Scott Whitney
Date:
Subject: Re: How to insert from linux to postgreSQL
Next
From: Silvio Brandani - SDB Information Technology Srl
Date:
Subject: ERROR: subtransaction logged without previous top-level txn record