Difference between revisions of "Pdm extract"
From SDU
| Line 2: | Line 2: | ||
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: pdm_extract [ | + | Usage: pdm_extract [-h] [-f] [-c] [-e] [-r] [-v] [-s] [-u] [-d] [-x] [-X] [ALL | database table names] |
| − | -h | + | {| |
| − | + | |- | |
| − | -c csv output | + | ! Command |
| − | -e csv output with double double quotes | + | ! Description |
| − | - r informal report output | + | ! Remarks |
| − | -v verbose | + | |- |
| − | -s | + | | -h |
| − | -u no headers | + | | Help |
| − | -d use dataent.fmt | + | | |
| − | -x locale sensitive numeric formats | + | |- |
| − | -X extract all tables except table list | + | | -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 | ||
| + | | | ||
| + | |- | ||
| + | |} | ||
Revision as of 21:46, 14 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 |