Custom Fields with custom data types

[thanaParis]

While reviewing the documentation for creating custom Fields, I didn't see any mention of how to go about changing the underlying database type.

I have a Postgres database with some unusual column types, such as name (see table 8.5) that I'm trying to make a Payload schema for. I also am interested in Point support for Postgres. Solving either of these problems, as far as I can tell, will require modifications to the interpretation of the 'type' field. Aka:

      {
        name: 'issuerName',
        type: 'text', // <- this field
        label: 'Issuer Name',
      }

Is there any documentation on custom Field type options? What would you say the level of effort would be for adding a custom Field type option?

[flowingkhaos]

I encountered the exact same issue here. I am using a postgres adapter to use supabase as DB, and i am working with AI technology to create a RAG system.

  {
  import { CollectionConfig } from 'payload'
  import type { Field } from 'payload'
  

    export const Articles: CollectionConfig = {
     slug: 'articles',
        fields: [
        {
          name: 'embedding',
          type: 'json', // <- i need to change this to a vector type
          required: true,
         },
        ]  as Field[],
  }

In this case, in order to store embeddings in the database articles table, the field type in the payload Article.ts collection file AND the column type in the DB table NEED to match. However as we all know there is a limited selection of types native to payloads framework:

array
blocks
checkbox
json
code
collapsible
date
email
group
number
point
radio
relationship
rich-text
select
tabs
text
textarea
ui
upload

so just like my collegue here i ask does anyone know how to create custom field types?