这是indexloc提供的服务,不要输入任何密码
Skip to content

support uuid type in console #142

@0x777

Description

@0x777

While UUID type is natively supported in Postgres, pgcrypto extension has to be enabled to add a default value.

Without default value:

CREATE TABLE article ( 
  id UUID PRIMARY KEY,
  title TEXT NOT NULL
)

With default value:

CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE TABLE article (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  title TEXT NOT NULL
);

Metadata

Metadata

Assignees

No one assigned

    Labels

    c/consoleRelated to consolec/serverRelated to serverk/enhancementNew feature or improve an existing feature

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions