Skip to main content
Bumped by Community user
Bumped by Community user
added 1 character in body; edited title
Source Link
user1822
user1822

How to get all variablecolumn names of a table in one column (PSQL)in multiple rows

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;

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;

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;
edited tags
Link
user1822
user1822
added 13 characters in body
Source Link

I have used the folowing to just view the variablescolumn names of a table (without any values) Is there a way to put view itall 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;

I have used the folowing to just view the variables of a table (without any values) Is there a way to put view it 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;

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;
Source Link
Loading