Template:Exodus console first steps: Difference between revisions
From NEOSYS Dev Wiki
Jump to navigationJump to search
(Created page with 'Try the following commands. {| !Command !!Comment |- |configexodus ||One time setup of default database and user in postgres (exodus and exodus) |- |<U>EDITING AND C…') |
No edit summary |
||
| Line 3: | Line 3: | ||
{| | {| | ||
!Command !!Comment | !Command !!Comment | ||
|- | |- | ||
|<U>EDITING AND COMPILING</U> | |<U>EDITING AND COMPILING</U> | ||
| Line 45: | Line 43: | ||
|} | |} | ||
If you get the following error then you have not completed the installation of | If you get the following error then you have not completed the installation of the Exodus plugin for Postgres. | ||
PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist | PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist | ||
Revision as of 22:04, 18 October 2010
Try the following commands.
| Command | Comment |
|---|---|
| EDITING AND COMPILING | |
| edic hello | edic=edit+compile+catalog. Creates a skeleton hello.cpp file using nano editor. edic will only compile on exit if saved, so make some change before you exit. |
| hello | Run it |
| compile hello | compile without editing |
| edic testsort | Browse a sample exodus program showing all fundamental database operations including dictionaries and list. |
| DATABASE OPERATIONS | |
| compile testsort | compile the preinstalled test program |
| testsort | Run it to generate some data and inspect the output |
| listfiles | quick tool avoiding need to use any database client |
| list myclients | text output - no page/column headers just yet sorry |
| list myclients (H) | html output (port of a fully blown LIST replacement in heavy production use since 2000) |
| list dict_myclients | NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work |
| list dict_voc | if you understand this then you understand your pick |
| edir myclients SB001 | you can edit data or dictionaries directly. edir="edit record" |
| delete myclients SB001 | useful command line tool |
| createfile tempfile | ditto |
| deletefile tempfile | ditto |
| createindex myclients CLIENT_TYPE | speeds up select commands on the indexed fields in the traditional way |
| deleteindex myclients CLIENT_TYPE | filenames are case insensitive, keys and fieldnames are CASE SENSITIVE |
If you get the following error then you have not completed the installation of the Exodus plugin for Postgres.
PGRES_FATAL_ERROR: ERROR: function exodus_extract_text(bytea, integer, integer, integer) does not exist
