PG_CURSORS
PG_CURSORS displays available cursors.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        Name  | 
      
        Text  | 
      
        Cursor name.  | 
     
| 
        statement  | 
      
        Text  | 
      
        Query statement when the cursor is declared to change.  | 
     
| 
        is_holdable  | 
      
        boolean  | 
      
        Whether the cursor is holdable (that is, it can be accessed after the transaction that declared the cursor has committed). If it is, its value is true.  | 
     
| 
        is_binary  | 
      
        boolean  | 
      
        Whether the cursor was declared BINARY. If it was, its value is true.  | 
     
| 
        is_scrollable  | 
      
        boolean  | 
      
        Whether the cursor is scrollable (that is, it allows rows to be retrieved in a nonsequential manner). If it is, its value is true.  | 
     
| 
        creation_time  | 
      
        Timestamp with time zone  | 
      
        Timestamp of the cursor.  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.