summaryrefslogtreecommitdiff
path: root/contrib/dbase/README.dbf2pg
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/dbase/README.dbf2pg')
-rw-r--r--contrib/dbase/README.dbf2pg139
1 files changed, 0 insertions, 139 deletions
diff --git a/contrib/dbase/README.dbf2pg b/contrib/dbase/README.dbf2pg
deleted file mode 100644
index 71548196550..00000000000
--- a/contrib/dbase/README.dbf2pg
+++ /dev/null
@@ -1,139 +0,0 @@
-
-
-
-dbf2sql(1L) dbf2sql(1L)
-
-
-NAME
- dbf2sql - Insert xBase-style .dbf-files into a Post-
- greSQL-table
-
-SYNOPSIS
- "dbf2pg [options] dbf-file"
- Options:
- [-v[v]] [-f] [-u | -l] [-c | -D] [-d database] [-t table]
- [-h host] [-s oldname=[newname][,oldname=[newname]]] [-b
- start] [-e end] [-W] [-U username] [-B transaction_size]
- [-F charset_from [-T charset_to]]
-
-
-DESCRIPTION
- This manual page documents the program dbf2pg. It takes
- an xBase-style .dbf-file, and inserts it into the speci-
- fied database and table.
-
- OPTIONS
- -v Display some status-messages.
-
- -vv Also display progress.
-
- -f Convert all field-names from the .dbf-file to low-
- ercase.
-
- -u Convert the contents of all fields to uppercase.
-
- -l Convert the contents of all fields to lowercase.
-
- -c Create the table specified with -t. If this table
- already exists, first DROP it.
-
- -D Delete the contents of the table specified with -t.
- Note that this table has to exists. An error is
- returned if this is not the case.
-
- -W Ask for password.
-
- -d database
- Specify the database to use. An error is returned
- if this database does not exists. Default is
- "test".
-
- -t table
- Specify the table to insert in. An error is
- returned if this table does not exists. Default is
- "test".
-
- -h host
- Specify the host to which to connect. Default is
- "localhost".
-
-
-
-
-
- 1
-
-
-
-
-
-dbf2sql(1L) dbf2sql(1L)
-
-
- -s oldname=[newname][,oldname=[newname]]
- Change the name of a field from oldname to newname.
- This is mainly used to avoid using reserved SQL-
- keywords. When the new fieldname is empty, the field
- is skipped in both the CREATE-clause and the
- INSERT-clauses, in common words: it will not be present
- in the SQL-table.
- Example:
- -s SELECT=SEL,remark=,COMMIT=doit
- This is done before the -f operator has taken
- effect!
-
- -b start
- Specify the first record-number in the xBase-file
- we will insert.
-
- -e end Specify the last record-number in the xBase-file we
- will insert.
-
- -B transaction_size
- Specify the number of records per transaction,
- default is all records.
-
- -U username
- Log as the specified user in the database.
-
- -F charset_from
- If specified, it converts the data from the speci-
- fied charset. Example:
- -F IBM437
- Consult your system documentation to see the con-
- versions available. This requires iconv to be enabled
- in the compile.
-
- -T charset_to
- Together with -F charset_from , it converts the
- data to the specified charset. Default is
- "ISO-8859-1". This requires iconv to be enabled
- in the compile.
-
-ENVIRONMENT
- This program is affected by the environment-variables as
- used by "PostgresSQL." See the documentation of Post-
- gresSQL for more info. This program can optionally use iconv
- character set conversion routines.
-
-BUGS
- Fields larger than 8192 characters are not supported and
- could break the program.
- Some charset convertions could cause the output to be
- larger than the input and could break the program.
-
-
-
-
-
-
-
-
-
-
-
-
-
- 2
-
-