Template:Exodus console first steps: Difference between revisions
From NEOSYS Dev Wiki
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Try the following commands. | Try the following commands. | ||
| Line 5: | Line 4: | ||
!Command !!Comment | !Command !!Comment | ||
|- | |- | ||
| | |<U>EDITING AND COMPILING</U> | ||
|- | |- | ||
|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. | |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. | ||
| Line 14: | 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 25: | 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 | |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 | |list dict_voc ||if you understand this then you understand your pick | ||
|- | |- | ||
|edir myclients SB001 ||you can edit data or dictionaries directly. edir= | |edir myclients SB001 ||you can edit data or dictionaries directly. edir="edit record" | ||
|- | |- | ||
|delete myclients SB001 ||useful command line tool | |delete myclients SB001 ||useful command line tool | ||
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
