How to get error line/column number from SQL syntax error or executing exception from libpq?

Question

When I execute a SQL command via libpq, it reports error message if there's some error something like this.

Error Domain=PQConnection Code=1 "ERROR:  syntax error at or near "fef"
LINE 1: fef
        ^

This is string message. I can parse the message - because it's very regular - to get line/column number, but that's unreliable. Is there any other API to get line/column numbers? Any regularized integer form would be nice.

eonil · Accepted Answer · 2013-10-22 17:34:36Z

1

Use PQresultErrorField function with key PG_DIAG_STATEMENT_POSITION.

From manual

PG_DIAG_STATEMENT_POSITION A string containing a decimal integer indicating an error cursor position as an index into the original statement string. The first character has index 1, and positions are measured in characters not bytes.

answered Oct 22, 2013 at 17:34

eonil

86.8k91 gold badges336 silver badges534 bronze badges

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

Collectives™ on Stack Overflow

How to get error line/column number from SQL syntax error or executing exception from libpq?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related