Redirect ERROR, FATAL and other messages

Поиск
Список
Период
Сортировка
От pittgs
Тема Redirect ERROR, FATAL and other messages
Дата
Msg-id 1326885605762-5154551.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Redirect ERROR, FATAL and other messages  (Jerry Sievers <gsievers19@comcast.net>)
Re: Redirect ERROR, FATAL and other messages  (hubert depesz lubaczewski <depesz@depesz.com>)
Список pgsql-general
Hello!

I'm executing a postgres command from a C code, the command that I introduce
is the following:

"sudo -u pgsql psql -p 3306 -d triage_dump -c 'insert into control select
*from uuid ' > logfile"

In the logfile, the output is introduced, but certain lines are not, like
for example:
*ERROR:  duplicate key value violates unique constraint "control_pkey"
DETAIL:  Key (uuid)=(10000717) already exists.
could not find a "psql" to execute*

I understand the error messages, but I don't want them to appear in the
screen (stdout), is there any way to send this messages to a log file? I
need all messages from postgres goes to a logfile, but seems is not enough
with "> logfile"
Can somebody give me a hint to solve my issue?

Thanks in advance
Gabs

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Redirect-ERROR-FATAL-and-other-messages-tp5154551p5154551.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: salah jubeh
Дата:
Сообщение: Table permessions
Следующее
От: Volodymyr Kostyrko
Дата:
Сообщение: scenario with a slow query