psql - add special variable to reflect the last query status - Mailing list pgsql-hackers

From Fabien COELHO
Subject psql - add special variable to reflect the last query status
Date
Msg-id alpine.DEB.2.20.1704042158020.12290@lancre
Whole thread Raw
Responses Re: psql - add special variable to reflect the last query status  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
After some discussions about what could be useful since psql scripts now 
accepts tests, this patch sets a few variables which can be used by psql 
after a "front door" (i.e. actually typed by the user) query:

  - RESULT_STATUS: the status of the query
  - ERROR: whether the query failed
  - ERROR_MESSAGE: ...
  - ROW_COUNT: #rows affected

  SELECT * FROM ;
  \if :ERROR
    \echo oops
    \q
  \endif

I'm not sure that the names are right. Maybe STATUS would be better than 
RESULT_STATUS.

-- 
Fabien.
Attachment

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: Re: PATCH: pageinspect / add page_checksum andbt_page_items(bytea)
Next
From: Andres Freund
Date:
Subject: Re: Parallel Append implementation