4 dbf2sql(1L) dbf2sql(1L)
8 dbf2sql - Insert xBase-style .dbf-files into a Post-
12 "dbf2pg [options] dbf-file"
14 [-v[v]] [-f] [-u | -l] [-c | -D] [-d database] [-t table]
15 [-h host] [-s oldname=newname[,oldname=newname]] [-s
16 start] [-e end] [-W] [-U username] [-B transaction_size]
17 [-F charset_from [-T charset_to]]
21 This manual page documents the program dbf2pg. It takes
22 an xBase-style .dbf-file, and inserts it into the speci-
23 fied database and table.
26 -v Display some status-messages.
28 -vv Also display progress.
30 -f Convert all field-names from the .dbf-file to low-
33 -u Convert the contents of all fields to uppercase.
35 -l Convert the contents of all fields to lowercase.
37 -c Create the table specified with -t. If this table
38 already exists, first DROP it.
40 -D Delete the contents of the table specified with -t.
41 Note that this table has to exists. An error is
42 returned if this is not the case.
47 Specify the database to use. An error is returned
48 if this database does not exists. Default is
52 Specify the table to insert in. An error is
53 returned if this table does not exists. Default is
57 Specify the host to which to connect. Default is
70 dbf2sql(1L) dbf2sql(1L)
73 -s oldname=newname[,oldname=newname]
74 Change the name of a field from oldname to newname.
75 This is mainly used to avoid using reserved SQL-
77 -s SELECT=SEL,COMMIT=doit
78 This is done before the -f operator has taken
82 Specify the first record-number in the xBase-file
85 -e end Specify the last record-number in the xBase-file we
89 Specify the number of records per transaction,
90 default is all records.
93 Log as the specified user in the database.
96 If specified, it converts the data from the speci-
97 fied charset. Example:
99 Consult your system documentation to see the con-
100 versions available. This requires iconv to be enabled
104 Together with -F charset_from , it converts the
105 data to the specified charset. Default is
106 "ISO-8859-1". This requires iconv to be enabled
110 This program is affected by the environment-variables as
111 used by "PostgresSQL." See the documentation of Post-
112 gresSQL for more info. This program can optionally use iconv
113 character set conversion routines.
116 Fields larger than 8192 characters are not supported and
117 could break the program.
118 Some charset convertions could cause the output to be
119 larger than the input and could break the program.