PostgreSQL Core Knowledge Deep Knowledge : Use with technology: for comprehensive documentation. Table Definition Common Queries Data Types | Type | Use For | |------|---------| | | Auto-increment IDs | | | Unique identifiers | | | Variable strings | | | Long text | | | JSON data (indexed) | | | Date and time | | | True/false | Performance - Use to check queries - Add indexes for WHERE/JOIN columns - Use over for queries - Partial indexes for filtered queries When NOT to Use This Skill - MySQL-specific syntax - Use skill for MySQL databases (AUTO INCREMENT, GROUP CONCAT) - NoSQL operations -…