[GENERAL] multiple sql results to shell

Поиск

Список

Период

Сортировка

От	Mark Lybarger
Тема	[GENERAL] multiple sql results to shell
Дата	23 октября 2017 г. 17:08:04
Msg-id	CAKM-gm+RQmkrO4GytBMN676P5f9cj=1TzdZXXZBWEn=sASvjeQ@mail.gmail.com обсуждение исходный текст
Ответы	Re: [GENERAL] multiple sql results to shell Re: [GENERAL] multiple sql results to shell
Список	pgsql-general

Дерево обсуждения

I have this bash/sql script which outputs some curl commands. the backticks causes it to get interpreted by the shell. This works fine if there is one result, but when there are many rows returned, it looks like one shell command.

any help on getting multiple rows returned to be executed by the shell would be appreciated!

thanks!

`psql -P "tuples_only=on" -h ${DB_HOST} -d ${DB_NAME} -U ${DB_USER} -c "select 'curl -X POST http://${REGISTER_HOST}:8080/' || source_id || '/${MT}/' || model || '/' || site || '/backoffice/register' from myschema.events where source_id = $SOURCE_ID and ineffective_date is null"`

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

[GENERAL] multiple sql results to shell