Postgres error codes

Question

How can I translate textual postgres error messages into error codes?

For example:

permission denied for relation table

Craig Ringer · Accepted Answer · 2017-08-03 01:29:19Z

2

Check your log_line_prefix setting in postgresql.conf. Make sure you use this %e option to log the codes in your postgres logs.

%e = SQL state

You can also use \set VERBOSITY verbose in psql to see detailed errors with SQLSTATE there.

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

answered Aug 2, 2017 at 15:45

postgresdba

362 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1