Difference between revisions of "Pdm extract"
From SDU
NeronLeVelu (Talk | contribs) (→Examples) |
|||
| Line 59: | Line 59: | ||
== Examples == | == Examples == | ||
| − | pdm_extract All > All.txt | + | * Extract the whole big stuff (USD only not full mdb) |
| + | pdm_extract All > All.txt | ||
| − | pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat | + | * Extract a filtered list |
| + | pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat | ||
| − | pdm_extract Priority > pri.txt | + | * Extract a full table |
| + | pdm_extract Priority > pri.txt | ||
| + | |||
| + | * Extract several table at once | ||
| + | pdm_extract Call_Request Activity_Log > call.dat | ||
Revision as of 14:49, 25 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 the whole big stuff (USD only not full mdb)
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
