"result = db.query(...)" returns a pgqueryobject.
By calling "result.getresult()", we can get the query result.

But I want to get the status information. Precisely the information
about frontend/backend protocal, after a SQL-statement is execute.

The following is a list of backend IPC commands (v3)
----------------------------------------------------
  Z - Zero / Ready for Query
  E - Error Code
  A - Notification
  P - Cursor Response
  B - Binary Row
  D - Data, Ascii
  C - Complete
  G - Copy IN
  H - Copy OUT
  I - Idle
  T - Row Description
  V - Function result

The following is a list of frontend IPC commands (v3)
----------------------------------------------------
  X - Quit
  Q - Query
  S - Sync
  E - Execute


For instance:
----------------------------------------------------
  SELECT * FROM my_table;
The backend protocal should return T (Row Description) and the frontend
protocal should return Q (Query)
----------------------------------------------------
  DROP TABLE my_table;
The backend protocal should return C (Complete) and the frontend
protocal should return Q (Query)


--Qian
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql

Reply via email to