From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | psql: show only failed queries |
Date: | 2014-03-01 11:01:15 |
Message-ID: | CAFj8pRAWyvFwKZHzJXNUVXskNE5dW4zU_U0GuZ88YLV9W1jSBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello
I was asked, how can be showed only failed queries in psql.
I am thinking, so it is not possible now. But implementation is very simple
What do you think about it?
bash-4.1$ psql postgres -v ECHO=error -f data.sql
INSERT 0 1
Time: 27.735 ms
INSERT 0 1
Time: 8.303 ms
psql:data.sql:3: ERROR: value too long for type character varying(2)
insert into foo values('bbb');
Time: 0.178 ms
INSERT 0 1
Time: 8.285 ms
psql:data.sql:5: ERROR: value too long for type character varying(2)
insert into foo values('ssssss');
Time: 0.422 ms
Regards
Pavel
Attachment | Content-Type | Size |
---|---|---|
echo-error.patch | text/x-patch | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2014-03-01 11:06:27 | Re: ALTER TABLE lock strength reduction patch is unsafe |
Previous Message | Pavel Stehule | 2014-03-01 08:37:48 | Re: proposal: new long psql parameter --on-error-stop |