Difference between revisions of "Pdm extract"
From SDU
(→Examples of Use) |
|||
| 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). | Use this command to dump data from the database to the screen or file (typically txt, dat, or csv). | ||
| − | |||
== Usage == | == Usage == | ||
Revision as of 02:03, 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
pdm_extract All > All.txt
pdm_extract -f "SELECT * FROM Call_Req" WHERE type = 'I'" > Call_Req.dat
pdm_extract Priority > pri.txt
