Alzabo...greSQL(3pm)

💅 NAME 💅

Alzabo::PostgreSQL — it's giving "Alzabo and PostgreSQL", bestie 🐘💖

---

✨ DESCRIPTION ✨

Okay so this page is all about the special support Alzabo has for PostgreSQL, plus the stuff it's lowkey missing. Full transparency, no gatekeeping 🫶

Postgres support is based on the 7.3.x version of Postgres. Alzabo should work with the 7.1 and 7.2 series, and it may even work with the 7.0 series. (Fingers crossed, fr fr 🙈)

---

🌸 Mixed-case Table or Column Names 🌸

By default, Postgres treats table and column names case-insensitively. Because of that, Alzabo always quotes these names when it's generating DDL SQL. Periodt.

If you're using tables or columns that contain upper-case characters, you should always call $schema->set_quote_identifiers(1) as soon as you load your schema object. Like, the second you load it. ⏰

Not me warning you again: if you don't do this, any method which generates DML SQL will fail. 💀 No cap.

---

🦋 Reverse Engineering 🦋

• Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the sequence was created as a result of making a column's type SERIAL.

This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change. It's just how it is, bestie 😭

---

🎀 Transactions 🎀

• Transactions are fully supported with Postgres. Slay. 👑

---

🌈 Outer joins 🌈

• Left and right outer joins are supported. 💖
• Full outer joins are not supported. 😔

---

⭐ Constraints ⭐

Column constraints can be specified as column attributes. Table constraints can be specified as table attributes.

Foreign key constraints are generated automatically based on the relationships defined by your schema. Iconic behaviour, honestly. ✨

---

That's the whole vibe check, bestie 🫶 this page is from perl v5.34.0, dated 2022-06-14, and it's part of the User Contributed Perl Documentation — go forth and quote those identifiers 💅🌸