Summary
Table Browser uses convertResultRowsToStringsAdaptive → internObject → Object.toString. postgres_table_utils.convertResultRowsToStrings (ISO DateTime) is unused. information_schema.columns.data_type is ARRAY / USER-DEFINED for arrays, enums, domains — formatLiteral then guesses.
Untouched bytea is OK if the column is not in SET. Editing timestamptz / bytea / jsonb / composite / enum cells is not a faithful round-trip.
Scope
- Display using PG-literal-friendly encoding (ISO timestamps,
\\x hex for bytea, JSON text for jsonb). Prefer udt_name (or format_type) over data_type for the codec.
- Tests against
docker/postgres/init/03_all_types.sql (or a subset): timestamptz, bytea, jsonb, enum, int[].
Out of scope
Summary
Table Browser uses
convertResultRowsToStringsAdaptive→internObject→Object.toString.postgres_table_utils.convertResultRowsToStrings(ISODateTime) is unused.information_schema.columns.data_typeisARRAY/USER-DEFINEDfor arrays, enums, domains —formatLiteralthen guesses.Untouched
byteais OK if the column is not inSET. Editing timestamptz / bytea / jsonb / composite / enum cells is not a faithful round-trip.Scope
\\xhex for bytea, JSON text for jsonb). Preferudt_name(orformat_type) overdata_typefor the codec.docker/postgres/init/03_all_types.sql(or a subset): timestamptz, bytea, jsonb, enum, int[].Out of scope