Difference between revisions of "Pdm extract"
From SDU
(→Examples) |
|||
| Line 1: | Line 1: | ||
| − | |||
Use this command to dump data from the database to the screen or file (typically txt, dat, or csv). | Use this command to dump data from the database to the screen or file (typically txt, dat, or csv). | ||
| Line 70: | Line 69: | ||
* Extract several table at once | * Extract several table at once | ||
pdm_extract Call_Request Activity_Log > call.dat | pdm_extract Call_Request Activity_Log > call.dat | ||
| + | |||
| + | |||
| + | ---- | ||
| + | |||
| + | To make corrections or additions to this article, select the ''edit'' tab above. | ||
| + | |||
| + | To discuss or ask questions about this article, select the ''discussion'' tab above. | ||
| + | |||
| + | |||
| + | [[Category:Commands|Commands man]] | ||
Revision as of 13:40, 27 January 2008
Use this command to dump data from the database to the screen or file (typically txt, dat, or csv).
Usage
pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names]
| Command | Description | Remarks |
|---|---|---|
| -h | Help | |
| -f | format string | |
| -c | csv output | |
| -e | csv output with double double quotes | |
| -r | informal report output | |
| -v | verbose | |
| -s | saved script | |
| -u | no headers | |
| -d | use dataent.fmt | |
| -x | locale sensitive numeric formats | |
| -X | extract all tables except table list |
Examples
- Extract all Service Desk tables
pdm_extract All > All.txt
- Extract a filtered list
pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat
- Extract a full table
pdm_extract Priority > pri.txt
- Extract several table at once
pdm_extract Call_Request Activity_Log > call.dat
To make corrections or additions to this article, select the edit tab above.
To discuss or ask questions about this article, select the discussion tab above.
