Skip to content

Improve server -> database package dbQuery handling of column types #519

@rblalock

Description

@rblalock

I'm currently manually tracking this:

const PG_OID = {
	UUID: '2950',
	BYTEA: '17',
	JSON: '114',
	JSONB: '3802',
	TIMESTAMP: '1114',
	TIMESTAMPTZ: '1184',
};

And doing my own bytesToUUID, etc. column type handling to normalize the rows of data I'm showing in the web app. The dbQuery columns returns something that forces me to handle the columns using postgres's OID. Its easy enough to add the look up but I assume we don't want to have agents or developers having to do this when they use this server package.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions