'How can I get a tablename of a PostgreSQL cursor?
I know that in Oracle we can do something like select * from TABLE(DBMS_XPLAN.DISPLAY_CURSOR('$$SQL_ID')). But there is no sql id field in pg_cursors catalog. We have only declaration text. And in general it's not Oracle. So, are there any ways to get a table name of an opened cursor in postgreSQL, besides parsing a sql statement(pg_cursors.statement)?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|