.\" Automatically generated by Pod::Man 4.07 (Pod::Simple 3.32)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.if !\nF .nr F 0
.if \nF>0 \{\
.    de IX
.    tm Index:\\$1\t\\n%\t"\\$2"
..
.    if !\nF==2 \{\
.        nr % 0
.        nr F 2
.    \}
.\}
.\" ========================================================================
.\"
.IX Title "DBS_DUMPTABSTRUCT 1p"
.TH DBS_DUMPTABSTRUCT 1p "2016-10-08" "perl v5.24.1" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
dbs_dumptabstruct \- Creates file set with SQL table schemas
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
dbs_dumptabstruct is an utility to create a file set with \s-1SQL\s0 table schemas.
For each table in the database dbs_dumptabstruct calls the appropriate dumper
utility with the output directed to a file named \fItable\fR.sql in the
current directory. dbs_dumptabstruct asks for a password if necessary.
.SH "COMMAND LINE PARAMETERS"
.IX Header "COMMAND LINE PARAMETERS"
Required command line parameters are the \s-1DBI\s0 driver
(\f(CW\*(C`Pg\*(C'\fR for Postgres or \f(CW\*(C`mysql\*(C'\fR for MySQL)
and the database name. The third parameter is optionally
and specifies the database user and/or the host where the
database resides (\f(CW\*(C`racke\*(C'\fR, \f(CW\*(C`racke@linuxia.de\*(C'\fR or \f(CW\*(C`@linuxia.de\*(C'\fR).
.SH "COMMAND LINE OPTIONS"
.IX Header "COMMAND LINE OPTIONS"
.SS "\fB\-d\fP=OPTIONS, \fB\-o\fP=OPTIONS, \fB\-\-dump\-options\fP=OPTIONS"
.IX Subsection "-d=OPTIONS, -o=OPTIONS, --dump-options=OPTIONS"
Pass options to the dumper utility, e.g. \f(CW\*(C`\-\-compatible=mysql40\*(C'\fR.
.SS "\fB\-p\fP, \fB\-\-pipe\fP"
.IX Subsection "-p, --pipe"
Prints the table dumps to standard output.
.SS "\fB\-t\fP TABLE[,TABLE,...], \fB\-\-tables\fP=TABLE[,TABLE,...]"
.IX Subsection "-t TABLE[,TABLE,...], --tables=TABLE[,TABLE,...]"
Comma-separated list of tables to dump.
.SS "\fB\-\-exclude\-matching\-tables\fP=REGEXP"
.IX Subsection "--exclude-matching-tables=REGEXP"
Excludes any table matching the regular expression \s-1REGEXP\s0 from dumping.
.SH "BUGS"
.IX Header "BUGS"
Only mysql and Pg drivers are supported.
.SH "AUTHOR"
.IX Header "AUTHOR"
Stefan Hornburg (Racke), racke@linuxia.de
.SH "VERSION"
.IX Header "VERSION"
0.17
.SH "SEE ALSO"
.IX Header "SEE ALSO"
\&\fIperl\fR\|(1), \fIDBIx::Easy\fR\|(3)