SQL::Translator::Parser::DBI::PostgreSQL - parser for DBD::Pg
See SQL::Translator::Parser::DBI.
Uses DBI to query PostgreSQL system tables to determine schema structure.
You can specify the following for "parser_args" in SQL::Translator :
If set to a true value, the parser will look for column types which are user-defined Enums, and generate a column definition like:
{ data_type => 'enum', extra => { custom_type_name => 'MyEnumType', list => [ 'enum_val_1', 'enum_val_2', ... ], } }
This makes a proper round-trip with SQL::Translator::Producer::PostgreSQL (which re-creates the custom enum type if producer_args->{postgres_version} >= 8.003) and can be translated to other engines.
producer_args->{postgres_version} >= 8.003
If the option is false (the default) you would just get
{ data_type => 'MyEnumType' }
with no provided method to translate it to other SQL engines.
Scott Cain <cain@cshl.edu>, previous author: Paul Harrington <harringp@deshaw.com>.
SQL::Translator, DBD::Pg.
To install SQL::Translator, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Translator
CPAN shell
perl -MCPAN -e shell install SQL::Translator
For more information on module installation, please visit the detailed CPAN module installation guide.