Difference between revisions of "Pdm extract"

From SDU
Jump to: navigation, search
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 help]
+
{|
[-f format string]
+
|-
-c csv output
+
! Command
-e csv output with double double quotes
+
! Description
- r informal report output
+
! Remarks
-v verbose
+
|-
-s saved_script
+
| -h
-u no headers
+
| Help
-d use dataent.fmt
+
|
-x locale sensitive numeric formats
+
|-
-X extract all tables except table list ]
+
| -f
ALL | database tables names...
+
| 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