PostgreSQL Commands

These some postgreSQL commands I use often.

Query retrieves all the enum types and their corresponding labels in the PostgreSQL database:

SELECT pg_type.typname AS enum_type, pg_enum.enumlabel AS enmu_label FROM pg_type JOIN pg_enum ON pg_enum.enumtypid = pg_type.oid;

Drops an enum type

DROP TYPE your_enum_type_here;