Forum OpenACS Development: help with dotlrn_communities table

Collapse
1: help with dotlrn_communities table
Posted by Philip Wang on 10/17/04 10:27 AM
hi, can anyone tell me how to see what values are stored in the table? (dotlrn_communities) i want to search for a community name (to get a community_id) and tried a search for pretty name, but says it's not in the table.
Collapse
2: Re: help with dotlrn_communities table (response to 1)
Posted by Deds Castillo on 10/17/04 12:26 PM
What RDBMS are you using?

On oracle, you can use sqlplus and do "desc tablename".  On postgres, you can use psql and do "\d tablename".

Of course you can use any other app that you are familiar with as long as it can display the schema.  You may also want to check the sql directory of the dotlrn package to see how the table was created if in case you don't have access to those tools.

Collapse
3: Re: help with dotlrn_communities table (response to 2)
Posted by Philip Wang on 10/17/04 12:51 PM
Thanks Deds, i'll try that out.