Re: How to insert from linux to postgreSQL

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.

Perl: https://www.perl.com/pub/1999/10/DBI.html/ <https://www.perl.com/pub/1999/10/DBI.html/>
Go: https://golang.org/pkg/database/sql/#DB.Prepare <https://golang.org/pkg/database/sql/#DB.Prepare>

> On Apr 8, 2019, at 3:03 PM, Campbell, Lance <lance(at)illinois(dot)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