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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
