Catalog table with cursor definition

From: Kelly Burkhart <kelly(dot)burkhart(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Catalog table with cursor definition
Date: 2010-06-16 13:04:03
Message-ID: AANLkTimhiz2HPd8Uo3w_E-oUpcqCvD5JHeVa-w_E2GYG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a catalog table or function to get the text of the query
associated with a cursor? If I query pg_stat_activity all I see is
'fetch forward 1000 from XYZ'.

-K

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2010-06-16 13:34:32 Re: Monitoring activities of PostgreSQL
Previous Message Yeb Havinga 2010-06-16 12:58:48 Re: consequent PQsendQueryPrepared() failed: another command is already in progress