Is there a way to load extensions fro Postgres database and how to distinguish user defined data types from system ones?

[Mamol27]

I didnt find any options to upload info about extensions in PG, maybe there is some additional?
And I didn't find any differences in columnDataTypes, which will mark as user defined

[Mamol27]

or maybe I can somehow add additional info into Catalog or maybe procedure with requests?

[sualeh]

Please look at the column data type schema to distinguish between the system and user-defined data types.

[Mamol27]

Yes, I looked on columnt data type and it has "system" like other.

[sualeh]

Please look at the schema, using getSchema().

[sualeh]

System column data types will have blank schemas.

[Mamol27]

Why using catalog.getColumnDataTypes(schema); I've got Tables as DataTypes?
INFO: Using SchemaCrawler database plugin for postgresql - PostgreSQL

[Mamol27]

and data types created by me, has ho schema

[sualeh]

If .getType() is system, then that is what the JDBC driver is returning.

[Mamol27]

its not system, this is mistake in your code.
DBeaver determines this is as user defined, I have request that 100% correctly determine user defined data types in Postgresql

SELECT n.nspname AS schema,
                       t.typname AS type_name,
                       t.typtype
                FROM pg_type t
                JOIN pg_namespace n ON n.oid = t.typnamespace
                LEFT JOIN pg_class c ON t.typrelid = c.oid
                WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')
                  AND c.oid IS NULL           -- exclude tables, views etc
                  AND t.typtype IN ('e', 'c', 'd') -- enum, composite, domain
                ORDER BY n.nspname, t.typname;

[Mamol27]

And catalog.getColumnDataTypes(schema); returns tables, not data types.