## Igor Korot (ikorot01(at)gmail(dot)com):
> std::string query1 = "DECLARE alltables CURSOR SELECT
> table_schema, table_name FROM information_schema.tables WHERE
> table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_type =
> 'LOCAL TEMPORARY';";
> [quote]
> RROR: syntax error at or near "SELECT"
> LINE 1: DECLARE alltables CURSOR SELECT table_schema, table_name FRO...
> What am I missing?
A "FOR" in front of the "SELECT":
https://www.postgresql.org/docs/current/static/sql-declare.html
Note you can use cursors via psql, too - only they have to be in a
transaction block (but postgres will tell you, once you got the
syntax right).
Regards,
Christoph
--
Spare Space