PSQLQueryTool Glossary
From DavinciWiki
(Difference between revisions)
(expanding description) |
(more on description) |
||
Line 7: | Line 7: | ||
<div style="clear:left"> | <div style="clear:left"> | ||
{{DavinciWiki_FunctionBox|Description| | {{DavinciWiki_FunctionBox|Description| | ||
− | In order to make the most of the MSFF PSQL Mars database, you must be familiar with the schema and table layout of the database. The examples, provided here allow you to access descriptions of the tables and columns available | + | In order to make the most of the MSFF PSQL Mars database, you must be familiar with the schema and table layout of the database. The examples, provided here allow you to access to descriptions of the tables and columns available for you to query. |
+ | |||
There are two sources for this information in the ''reference'' schema: | There are two sources for this information in the ''reference'' schema: | ||
− | # | + | # [reference.]pubmars_glossary |
− | + | #: This is a VIEW based on joining several of the postgres control tables which define the actual Mars data tables; this includes tables in the ''public'' schema. Field descriptions will be null, if the table author did not populate a descriptive comment about the column. | |
− | #: This is a | + | #: ''Suggested selection-list fields'': schema_name, table_name, column_name, datatype_name, description |
− | #: Suggested selection list fields: schema_name, table_name, column_name, datatype_name, description | + | # [reference.]glossary |
#: This is a hand-updated table describing all of the tables under the control of THEMIS Mission-Operations; the descriptions provided here may be more verbose than those in the pubmars_glossary | #: This is a hand-updated table describing all of the tables under the control of THEMIS Mission-Operations; the descriptions provided here may be more verbose than those in the pubmars_glossary | ||
− | #: Suggested selection list fields: table_name, field_name, value_type, description | + | #: ''Suggested selection-list fields:'' table_name, field_name, value_type, description |
− | #: Suggested constraints: schema_name | + | #: ''Suggested constraints:'' schema_name='thmpub' |
+ | |||
+ | The examples provided will get you started; you should refine the ''constraints-list'' and the ''order-by-list'' according to your needs. | ||
}} | }} | ||
{{DavinciWiki_FunctionBox|Procedure| | {{DavinciWiki_FunctionBox|Procedure| |
Revision as of 19:02, 7 April 2014
Contents: Description, Procedure
Description In order to make the most of the MSFF PSQL Mars database, you must be familiar with the schema and table layout of the database. The examples, provided here allow you to access to descriptions of the tables and columns available for you to query. There are two sources for this information in the reference schema:
The examples provided will get you started; you should refine the constraints-list and the order-by-list according to your needs.
Procedure {{{2}}} |
DavinciWiki Mini-Nav Bar Contents
Contact Developers
All other topics
Functions Used {{{3}}}
Related Procedures {{{4}}} |