Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

support of jsonb in postgresql #340

Closed
nosovk opened this issue Mar 19, 2023 · 2 comments
Closed

support of jsonb in postgresql #340

nosovk opened this issue Mar 19, 2023 · 2 comments

Comments

@nosovk
Copy link

nosovk commented Mar 19, 2023

When I try to convert PGSQL ddl using sql2dbml I got errors on JSONB fields, for example:

create table profile.events
(
  id         uuid                     default gen_random_uuid() not null,
  data       jsonb                    default '{}'::jsonb       not null,
  created_at timestamp with time zone default now()             not null,
);

the part about ::jsonb broke conversion

@nguyenalter
Copy link
Contributor

We don't currently support the PostgreSQL type cast :: operator. We'll let you know when we support this syntax.

@NQPhuc
Copy link
Contributor

NQPhuc commented Sep 7, 2023

Fixed in #416

@NQPhuc NQPhuc closed this as completed Sep 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants