Can I get original Query from PGresult* object in Postgres?

Question

mConn = PQconnectdb( conninfo );
const char* pQuery = "SELECT X FROM Y...";
PGresult* stmt = PQexec( mConn, pQuery );

can I do this?

char * original_query = Take( stmt );

thx

score 1 · Answer 1 · answered Jun 21 '11 at 08:55

1

See current_query() and its source code.

answered Jun 21 '11 at 08:55

Denis de Bernardy

score 1 · Accepted Answer · answered Jun 22 '11 at 04:21

1

No, the PGresult structure does not contain that information. You need to save it yourself somehow.

answered Jun 22 '11 at 04:21

Peter Eisentraut

2 Answers2