Re: How to insert from linux to postgreSQL

Поиск
Список
Период
Сортировка
От Frank Alberto Rodriguez
Тема Re: How to insert from linux to postgreSQL
Дата
Msg-id a8419f27b80e56b93cd2e53a155b4e37125a9c67.camel@gmail.com
обсуждение исходный текст
Ответ на How to insert from linux to postgreSQL  ("Campbell, Lance" <lance@illinois.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Peter M. Groen"
Дата:
Сообщение: Re: How to insert from linux to postgreSQL
Следующее
От: arnab biswas
Дата:
Сообщение: Postgresql.conf file not found after database restart.