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 |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 3: | Line 3: | ||
{| | {| | ||
!Command !!Comment | !Command !!Comment | ||
|- | |- | ||
|<U>EDITING AND COMPILING</U> | |<U>EDITING AND COMPILING</U> | ||
| Line 15: | Line 13: | ||
|- | |- | ||
|edic testsort ||Browse a sample exodus program showing all fundamental database operations including dictionaries and list. | |edic testsort ||Browse a sample exodus program showing all fundamental database operations including dictionaries and list. | ||
|- | |- | ||
|compile testsort ||compile the preinstalled test program | |compile testsort ||compile the preinstalled test program | ||
|- | |- | ||
|testsort ||Run it to generate some data and inspect the output | |testsort ||Run it to generate some data and inspect the output | ||
|- | |||
|<U>DATABASE OPERATIONS</U> | |||
|- | |- | ||
|listfiles ||quick tool avoiding need to use any database client | |listfiles ||quick tool avoiding need to use any database client | ||
| Line 26: | Line 24: | ||
|list myclients ||text output - no page/column headers just yet sorry | |list myclients ||text output - no page/column headers just yet sorry | ||
|- | |- | ||
|list myclients | |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_myclients ||NB the underscore after "dict" is *required*. "dict(SPACE)myclients" wont work | ||
| 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 | ||
Latest revision as of 01:50, 3 June 2011
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. |
| compile testsort | compile the preinstalled test program |
| testsort | Run it to generate some data and inspect the output |
| DATABASE OPERATIONS | |
| 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
