I have used the folowingfollowing to just view the column names of a table (without any values) Is there a way to view all column names in one column but separate rows? Maybe do a lateral join? Open for suggestions. It is for exploratory purposes only.
This is what I used so far:
select *
from fi.questionnaire
where false;