database/drives/postgres/parse.go::queryEnums query adds an enum per enum value rather than actual enum

[oiime]

The current query:

SELECT      n.nspname, t.typname as type
    FROM        pg_type t
    LEFT JOIN   pg_catalog.pg_namespace n ON n.oid = t.typnamespace
    JOIN        pg_enum e ON t.oid = e.enumtypid
    WHERE       (t.typrelid = 0 OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid))
    AND     NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type el WHERE el.oid = t.typelem AND el.typarray = t.oid)
    AND     n.nspname IN (%s)

Would add an entry per each enum value, not for each enum, causing duplication on generation, I'd like to make a PR replacing it with the following:

SELECT n.nspname, t.typname AS type
    FROM pg_type t 
    JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace 
    WHERE typtype='e'
    AND n.nspname IN (%s)

Would create a PR for that

[oiime]

@natefinch any chance to consider that? seems too minor to keep a fork for

[natefinch]

Ahh yeah, that looks good, thanks!