Skip to main content
2 of 4
added 13 characters in body

How to get all variable names of a table in one column (PSQL)

I have used the folowing to just view the column names of a table (without any values) Is there a way to view all column names in one column? 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;