1
.TH dbf2sql 1L \" -*- nroff -*-
3
dbf2sql \- Insert xBase\-style .dbf\-files into a PostgreSQL\-table
5
.B dbf2pg [options] dbf-file
10
[-v[v]] [-f] [-u | -l] [-c | -D] [-d database] [-t table]
11
[-h host] [-s oldname=[newname][,oldname=[newname]]]
12
[-b start] [-e end] [-W] [-U username] [-B transaction_size]
13
[-F charset_from [-T charset_to]]
16
This manual page documents the program
18
It takes an xBase-style .dbf-file, and inserts it into the specified
23
Display some status-messages.
26
Also display progress.
29
Convert all field-names from the .dbf-file to lowercase.
32
Convert the contents of all fields to uppercase.
35
Convert the contents of all fields to lowercase.
38
Create the table specified with
40
If this table already exists, first
45
Delete the contents of the table specified with
47
Note that this table has to exists. An error is returned if this is not the
54
Specify the database to use. An error is returned if this database does not
55
exists. Default is "test".
58
Specify the table to insert in. An error is returned if this table does not
59
exists. Default is "test".
62
Specify the host to which to connect. Default is "localhost".
64
.I "-s oldname=newname[,oldname=newname]"
65
Change the name of a field from
69
This is mainly used to avoid using reserved SQL-keywords. Example:
72
-s SELECT=SEL,COMMIT=doit
79
operator has taken effect!
82
Specify the first record-number in the xBase-file we will insert.
85
Specify the last record-number in the xBase-file we will insert.
87
.I "-B transaction_size"
88
Specify the number of records per transaction, default is all records.
91
Log as the specified user in the database.
94
If specified, it converts the data from the specified charset. Example:
100
Consult your system documentation to see the convertions available.
105
, it converts the data to the specified charset. Default is "ISO-8859-1".
107
This program is affected by the environment-variables as used
110
See the documentation of PostgresSQL for more info.
112
Fields larger than 8192 characters are not supported and could break the
115
Some charset convertions could cause the output to be larger than the input
116
and could break the program.