SQL::Tr...tgreSQL(3)

okay bestie, welcome to the SQL::Tr...tgreSQL(3) page 💅 — it lives under User Contributed Perl Documentation, and it is literally giving “tiny manpage, very specific job” energy. let’s go ✨

🌸 NAME 🌸

SQL::Translator::Parser::DBI::PostgreSQL — a parser for DBD::Pg. periodt 💖

✨ SYNOPSIS ✨

See SQL::Translator::Parser::DBI, bestie. that’s the whole synopsis 🫶

💖 DESCRIPTION 💖

Uses DBI to query PostgreSQL system tables and determine the schema structure. no cap, that’s the job 🔥

🎀 CONFIGURATION 🎀

You can specify the following for parser_args in SQL::Translator, bestie:

💅 deconstruct_enum_types 💅

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. slay 💜

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. so yeah, that’s the documented default vibe 🙈

reminder, bestie: the option is false by default, and with { data_type => 'MyEnumType' } there’s no provided method to translate it to other SQL engines. that’s literally what the page says 💅

👑 AUTHOR 👑

Scott Cain <cain@cshl.edu>, previous author: Paul Harrington <harringp@deshaw.com>. iconic ✨

🌈 SEE ALSO 🌈

SQL::Translator, DBD::Pg. go read those too, bestie 💖

---

that’s the whole page, bestie 🫶 — source/version: perl v5.42.0, dated 2024-12-12, filed under SQL::Tr...tgreSQL(3). now go query some system tables 💅✨