Skip to content

Add support for jsonpath column type for postgres #10456

@nialexsan

Description

@nialexsan

Feature Description

jsonpath column type is not supported by TypeORM
this type was added in Postgres 12:
https://www.postgresql.org/docs/12/datatype-json.html#DATATYPE-JSONPATH

jsonpath acts like a simple string outside of the database
this type is mostly used in stored functions and procedures for json related operations inside the database engine

The Solution

add support for jsonpath column type

Considered Alternatives

currently it's possible to work with jsonpath treating it as a simple string, but it requires custom transformers and migrations to create a jsonpath column in a table

Additional Context

No response

Relevant Database Driver(s)

  • aurora-mysql
  • aurora-postgres
  • better-sqlite3
  • cockroachdb
  • cordova
  • expo
  • mongodb
  • mysql
  • nativescript
  • oracle
  • postgres
  • react-native
  • sap
  • spanner
  • sqlite
  • sqlite-abstract
  • sqljs
  • sqlserver

Are you willing to resolve this issue by submitting a Pull Request?

Yes, I have the time, and I know how to start.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions