PostgresErrorException

The SQLSTATE code for the error (see Appendix A) .Not localizable .Always present .

If the error was associated with a specific table column, the name of the column .(Refer to the schema and table name fields to identify the table.)

If the error was associated with a specific constraint, the name of the constraint .Refer to fields listed above for the associated table or domain .(For this purpose, indexes are treated as constraints, even if they weren't created with constraint syntax.)

If the error was associated with a specific data type, the name of the data type .(Refer to the schema name field for the name of the data type's schema.)

The file name of the source-code location where the error was reported .

Defined the same as the P field, but used when the cursor position refers to an internally generated command rather than the one submitted by the client .The query field will always appear when this field appears.

The text of a failed internally-generated command .This could be, for example, a SQL query issued by a PL/pgSQL function.

The line number of the source-code location where the error was reported .

The name of the source-code routine reporting the error .

If the error was associated with a specific database object, the name of the schema containing that object, if any.

The field contents are ERROR, FATAL, or PANIC (in an error message), or WARNING, NOTICE, DEBUG, INFO, or LOG (in a notice message), or a localized translation of one of these .Always present.

If the error was associated with a specific table, the name of the table .(Refer to the schema name field for the name of the table's schema.)

An indication of the context in which the error occurred .Presently this includes a call stack traceback of active procedural language functions and internally-generated queries .The trace is one entry per line, most recent first.

Returns a string representation of the object.

The default representation is platform dependent.