1. PostgreSQL Migration for New User Fields
Backend DeveloperBackground
Preparing a production deployment that adds email tracking to the users table with a performance index.
Problem
Need to ensure the ALTER TABLE syntax is correct and includes the new index without dropping existing data.
How to use
Paste the current CREATE TABLE users DDL into Source Schema, paste the updated DDL with the email column and CREATE INDEX statement into Target Schema, then select PostgreSQL dialect.
Outcome
Receives the exact ALTER TABLE statement to add the NOT NULL email column and the CREATE INDEX command ready for migration.