Sample Header Ad - 728x90

Anyway to view original query on top of views using postgres

0 votes
1 answer
282 views
For example, I have a simple query:
SELECT * FROM information_schema.columns where table_schema = 'public';
Which turn out very complex, information_schema.columns is a complex view. Right now, to understand the query, I need to read all the definitions of all the views involved. Is there any way to "expand" query and make it easier to read side by side with query plan output?
Asked by nvcnvn (101 rep)
Apr 25, 2021, 10:52 AM
Last activity: May 15, 2025, 04:05 AM