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!