logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

dbs_dumptabstruct - Creates file set with SQL table schemas

Author

       Stefan Hornburg (Racke), racke@linuxia.de

Bugs

       Only mysql and Pg drivers are supported.

Command Line Options

-d=OPTIONS,-o=OPTIONS,--dump-options=OPTIONS
       Pass options to the dumper utility, e.g. "--compatible=mysql40".

   -p,--pipe
       Prints the table dumps to standard output.

   -tTABLE[,TABLE,...],--tables=TABLE[,TABLE,...]
       Comma-separated list of tables to dump.

   --exclude-matching-tables=REGEXP
       Excludes any table matching the regular expression REGEXP from dumping.

Command Line Parameters

       Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the
       database name. The third parameter is optionally and specifies the database user and/or the host where
       the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").

Description

       dbs_dumptabstruct is an utility to create a file set with SQL table schemas.  For each table in the
       database dbs_dumptabstruct calls the appropriate dumper utility with the output directed to a file named
       table.sql in the current directory. dbs_dumptabstruct asks for a password if necessary.

Name

       dbs_dumptabstruct - Creates file set with SQL table schemas

See Also

perl(1), DBIx::Easy(3)

perl v5.38.2                                       2024-03-24                              DBS_DUMPTABSTRUCT(1p)

Version

       0.17

See Also