Difference between revisions of "Pdm extract"
From SDU
| Line 1: | Line 1: | ||
[[Category:Commands|Commands man]] | [[Category:Commands|Commands man]] | ||
| − | + | 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] | ||
| + | <br> | ||
{| | {| | ||
|- | |- | ||
| Line 55: | Line 57: | ||
|- | |- | ||
|} | |} | ||
| + | |||
| + | |||
| + | == Examples of Use == | ||
| + | pdm_extract All > All.txt | ||
| + | |||
| + | pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat | ||
| + | |||
| + | pdm_extract Priority > pri.txt | ||
Revision as of 00:28, 17 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 of Use
pdm_extract All > All.txt
pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat
pdm_extract Priority > pri.txt
