search

xtdb / xtdb

An immutable SQL database for application development, time-travel reporting and data compliance. Developed by @juxt
https://xtdb.com
Mozilla Public License 2.0
2.57k stars 169 forks source link

Return standard SQL types in information_schema.data_type #3783

Open egg-juxt opened 1 month ago

egg-juxt commented 1 month ago

Otherwise SQL tools, like Metabase, are not able to make sense of it.

Postgres returns types like: name smallint inet boolean numeric regproc timestamp with time zone bigint pg_dependencies xid "char" (including the double quotes. why?) character varying pg_lsn interval pg_node_tree text anyarray regtype USER-DEFINED double precision ARRAY pg_ndistinct pg_mcv_list bytea integer real oid

XTDB currently returns an EDN.

egg-juxt commented 1 month ago

Metabase doesn't seem to rely on information_schema.columns, but on pg_catalog.pg_attributes (and pg_class and pg_index), so removing the "metabase" tag.