On 2/12/22 19:11, Andreas 'ads' Scherbaum wrote:
The complaint is not about complex queries, or CTEs, or Joins. This is
about simple queries where a user wants to discover - surf - the database
and look into specific tables, but exclude certain columns. More
specifically,
this is when the user types in interactive queries.
There is already something very similar to what you are describing:
https://www.psycopg.org/docs/cursor.html
Each cursor has its description, which consists of the column
descriptions. Basically, it's like doing \d on a cursor. Unfortunately,
it's not interactive, one has to do some pythong programming in order do
to that. Unfortunately, it is not possible to just "describe the
cursor", the description becomes available after the "execute" call.
Hopefully, I understood you correctly.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
