Can we see query fields in Workplace?

Can we also pull query fields into workplace when we query data? How to do it?

[Walter Roberson]

Please use meaningful tags. http://www.mathworks.co.uk/matlabcentral/answers/43073-a-guide-to-tags

[Walter Roberson]

Is this a Simulink question? A database question?

[Nan Shen]

database question

[Walter Roberson]

Could you give an example of what you would like to do?

[Nan Shen]

I use query builder to query data from our database. it pops up a variable with data I need. But what I also need are names of those columns (fields in Query Builder). Can we have another varible in workspace showing the field names? thanks!

Answer 1

[the cyclist]

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.