Info
이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
Can we see query fields in Workplace?
조회 수: 1 (최근 30일)
이전 댓글 표시
Can we also pull query fields into workplace when we query data? How to do it?
댓글 수: 5
답변 (1개)
the cyclist
2013년 1월 25일
There is no way that I know of to return the column names along with the data of those columns. (It would be a bit odd to do so, since the names and data may be of different types.)
You can query the metadata of the database to get column names. For example, in postgresql you can write
SELECT attname , typname FROM pg_attribute , pg_type WHERE
typrelid=attrelid AND typname = 'table_name' ;
to find the columns for the table named table_name.
댓글 수: 0
이 질문은 마감되었습니다.
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!