View Full Version : Qt c++ - how to show a refcursor retrieving from a postgres stored procedure?

26th June 2014, 15:04
Qt postgres stored procedures
Hello, i have a trouble, i have a postgres stored function that should retrieve a ref cursor, when i call it with this instructions:

qdb.prepare("SELECT * from myfunction('cursor'); fetch all in cursor" );

and i try to show it in a tableview:

QSqlQueryModel *model = new QSqlQueryModel;



In the tableview i only see the name of the cursor instead of the table.

So where's the problem? :confused:
when i use the same SQL query in pgadmin it returns me the table, so it goes good, but does it go wrong in Qt? Where am i wrong? :confused:
Thenks for the help!! :o