Where to find description of a clinical trial?

[callmecary]

I think they used to be the column of brief_summaries, but now they are empty. Can you please point me to the new table if it's ever moved. Thank you!

[datnoor]

Lianze: It appears that the table ctgov.brief_summaries has a column "description" containing the brief_summary. This field has values. The sql query tool may not show the text populated in the column. If you export the results as CSV, the text will show,

…

On Sun, Aug 5, 2018 at 8:53 PM, Lianze MA ***@***.***> wrote: I think they used to be the column of brief_summaries, but now they are empty. Can you please point me to the new table if it's ever moved. Thank you! — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#749>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AB2aoka-mOHt855ILe4Pm-HSgO38av4Xks5uN5N1gaJpZM4VvnA7> .

[tibbs001]

If I remember right, a while back I noticed that pgAdmin did not always display the content of certain text columns. (I think it was pgAdmin, but don't remember the version.) I just ran the following query: select description from brief_summaries where nct_id='NCT03615508'; using psql and it returns the value in that column. As datnoor mentioned, it seems to be related to the query tool. You might try using a different one. I'm able to see the content of ctgov.brief_summaries.description using psql versions 9.2.23 & 10.4.

[callmecary]

Thank you guys, yes, it is bc of the query tool. I am using pgAdmin4 v3 on windows. I was using the same tool on Mac OS and didn't remember there were empty columns. That's why I am confused. Thanks again!