Difference between revisions of "Pdm extract"
From SDU
m (→Examples) |
m |
||
| Line 1: | Line 1: | ||
| + | [[Category:Commands]] | ||
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 69: | Line 70: | ||
* Extract multiple tables | * Extract multiple tables | ||
pdm_extract Call_Request Activity_Log > call.dat | pdm_extract Call_Request Activity_Log > call.dat | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
---- | ---- | ||
| − | <div align='center'><font color=" | + | <div align='center'><font color="green">To make corrections or additions to this article, select the ''edit'' tab above.<br> |
To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | To discuss or ask questions about this article, select the ''discussion'' tab above.</font></div> | ||
| − | |||
| − | |||
Revision as of 16:36, 18 July 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 multiple tables
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.
To discuss or ask questions about this article, select the discussion tab above.
