Skip to main content
4 of 4
added 1 character in body; edited title
user avatar
user avatar

How to get all column names of a table in in multiple rows

I have used the following 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;